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


"Josh Smith" <Josh wrote in message
...
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.