Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Scott_F
 
Posts: n/a
Default How do I show the Grand Total on a Pivot Chart?

I am creating Pivot Tables in Excel and at the bottom of the pivot table, it
will show the total for each column. When I create a Pivot Chart, these
values are lost. I would like to show them somewhere on the pivot chart.
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default How do I show the Grand Total on a Pivot Chart?

You can't include the Grand Total in a pivot chart. You could create a
normal chart, based on the pivot table, and include the totals in that.

On Jon Peltier's site, there are instructions for creating a normal
chart from pivot data:

http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm



Scott_F wrote:
I am creating Pivot Tables in Excel and at the bottom of the pivot table, it
will show the total for each column. When I create a Pivot Chart, these
values are lost. I would like to show them somewhere on the pivot chart.



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

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 issue James Charts and Charting in Excel 8 September 13th 05 12:35 PM
How do I show range of data in an area chart? slycke Charts and Charting in Excel 1 September 1st 05 01:11 PM
Pivot Chart HELP Steve Charts and Charting in Excel 1 August 15th 05 06:31 PM
Pivot Chart Jojomay Charts and Charting in Excel 1 June 16th 05 07:00 PM
using the PIVOT TABLE and CHART Big Red Excel Discussion (Misc queries) 1 November 29th 04 08:42 PM


All times are GMT +1. The time now is 01:31 AM.

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"