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 / April 2008

Tip: Looking for answers? Try searching our database.

displaying totals in a pivot chart

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Josh Smith - 10 Apr 2008 04:23 GMT
I want to display the grand total from a pivot table in a pivot chart. In a
static chart I normaly just reference the cell with the total to be displayed
as the chart title. How can I do this with a pivot chart.
Shane Devenshire - 12 Apr 2008 22:39 GMT
Hi Josh,

If you are plotting a line chart then change the chart type to stacked line.
One at a time select each of the lines below the top one (it represents the
total) and format their line to None.

If you are plotting a column chart change it to a stacked column.   Make all
the series the same color.  Set the borders for each of the series to None.

In both cases you can turn off the Legend.

Cheers,
Shane Devenshire
Microsoft Excel MVP

> I want to display the grand total from a pivot table in a pivot chart. In
> a
> static chart I normaly just reference the cell with the total to be
> displayed
> as the chart title. How can I do this with a pivot chart.
Debra Dalgleish - 13 Apr 2008 13:45 GMT
In a blank cell in the workbook, type an equal sign, then click on the
grand total cell in the pivot table. Unless you've changed the default
settings, this should create a GETPIVOTDATA formula, such as:
  =GETPIVOTDATA("Total",$A$3)
Format the cell as you want it to appear on the chart.

Next, select the pivot chart and type an equal sign. You'll see it in
the formula bar as you type.
Then, click on the cell with the GETPIVOTDATA formula, and press Enter

The grand total will appear in a text box in the centre of the pivot
chart. Drag it to the position you want it displayed, and format it.

> I want to display the grand total from a pivot table in a pivot chart. In a
> static chart I normaly just reference the cell with the total to be displayed
> as the chart title. How can I do this with a pivot chart.

Signature

Debra Dalgleish
Contextures
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.