Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pivot tables/charts in XP

Status
Not open for further replies.

alibongo

IS-IT--Management
Sep 6, 2001
29
GB
Hi,

I am only used to Win97/2000 Excel and I am struggling with some basic functionality.

When I create a pivot table I don't seem to be able to view the grand totals in my chart associated with the pivot table.

Therefore, I can't run a grand total/trendline against one axis and all the other series on the other axis.

I know this must be something obvious I haven't done but I am stumped for now!?

Cheers, Alistair
 
Hi Skip,

Yes I have checked that the table options has the grand total for rows and columns ticked, it just won't let me have these totals as a series.

Any more ideas would be much appreciated.

Thanks, Alistair
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top