#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 53
Default Pivot Table Chart

Hi, I have got a pivot table with about 12 rows and 2 colums of data, which
are summed from elsewhere in the sreadsheet.

I've then got a Pivot Table chart which displays the data in nice pretty
columns, with the totals below in a grid.

However in my actual pivot table, the two colums are summed themselves into
"grand totals" - how do I get this data to display on the chart - I've tried
"grouping" which gives me the values I want, but of course that screws all
the individual row data - is there just an opion somewher which says "display
totals as text on chart" ??

Thanks
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Chart Created from Pivot Table is Blank RaidersFan Charts and Charting in Excel 1 January 25th 09 10:34 PM
How to create chart from Pivot table but not Pivot chart? Daniel Charts and Charting in Excel 1 July 31st 07 01:32 AM
When refreshing pivot tables my pivot table chart type changes hannah220507 Excel Discussion (Misc queries) 1 May 22nd 07 02:57 PM
Exclude pivot table data from pivot chart? coal_miner Charts and Charting in Excel 4 April 17th 07 07:11 AM
Pivot Table Chart - With Pivot Table Totals WCM Charts and Charting in Excel 0 November 29th 06 03:21 PM


All times are GMT +1. The time now is 08:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"