LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default Showing Pivot Table total on Associated Pivot Chart

Hi

I have a pivot chart created from a pivot table, showing individual values
for each of the items. The pivot table also shows a 'total' for the items.
I would like to display the 'total' on the pivot chart as a line running
across the chart (ie plot it as a point associated with each of the items).
Is there a way to do this? I have tried creating a new column on the
worksheet and trying a copy/paste onto the chart area, but this does not work.

Appreciate any help available on this one

Thanks
--
KenY
 
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
Exclude pivot table data from pivot chart? coal_miner Charts and Charting in Excel 4 April 17th 07 07:11 AM
How do I set up Multicharts with Pivot Table / Pivot Chart ? TonyGB007 Charts and Charting in Excel 0 December 8th 05 01:37 PM
Pivot Table not showing subtotals Glenn Excel Discussion (Misc queries) 1 July 15th 05 12:41 PM
Grand Total on Pivot Table turned on but no totals showing GaryRitchie Excel Discussion (Misc queries) 0 June 15th 05 02:13 PM
How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. Jersey Girl Excel Discussion (Misc queries) 1 March 10th 05 04:20 AM


All times are GMT +1. The time now is 04:22 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"