Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / November 2003

Tip: Looking for answers? Try searching our database.

Pivot chart total series

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jay - 05 Nov 2003 22:36 GMT
When I use the pivot chart how can I display the grand totals (which are calculated by the table) as a series?  I'm talking about the row and column totals that are calculated when you have the correct box selected in pivot table options.
Debra Dalgleish - 05 Nov 2003 23:23 GMT
I don't know of any way to include the totals in a PivotChart. You could
create a normal chart, based on the pivot table, and include the totals
in that.

To create a normal chart from a Pivot Table:

1. Select an empty cell away from the Pivot Table.
2. Click the Chart Wizard button.
3. Click Finish, to create an empty chart.
4. Select cells in the Pivot Table, and drag them to the blank chart.

Note: If you select a cell which contains a Pivot Table button, the
chart will become a Pivot Chart.

To avoid this, you can build the chart from the data and either the
series or category axis labels. Then choose Chart>Source Data. On the
Series tab, select a series. Click on a worksheet cell to add the series
name or Category axis label.

> When I use the pivot chart how can I display the grand totals (which are calculated by the table) as a series?  I'm talking about the row and column totals that are calculated when you have the correct box selected in pivot table options.

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.