grand total column in chart

[Synergy Builders]

Sometime the ansewer in so simple I look past it. But how do you show the automated grand total in a line chart.

 

[Synergy Builders]

Can somebody help with this simple question

 

[Gerald Higgins]

What is the "automated grand total", and how do you want to show it in a chart ?

 

[Caliche]

Can somebody help with this simple question

Is this

http://www.andypope.info/charts/StackColTotal.htm

you are looking for?

HTH

Caliche

 

[Synergy Builders]

yes this is where I want to start but with the stacked chart to add a total line chart type with a moving average trend line for comparision

 

[Synergy Builders]

would it help if I include an example

 

[Datsmart]

Take a look at this Demo from DataPig:
http://www.datapigtechnologies.com/flashfiles/addavgline.html

 

[Synergy Builders]

I love the data pig website and visit it often. Im using a stacked column chart with several sources. In pivot chart it has the grand total column but Im having a hard time getting it to show on a chart.

 

[Jon Peltier]

It took you five posts to get around to saying it was a pivot chart. None of the items suggested work on pivot charts, because you can't add data from outside the pivot table, and pivot charts don't show subtotals or grand totals. You could create a regular chart using pivot table data: select a blank cell away from the pivot table, start the chart wizard, and on step 2, click on the Series tab, and add each series separately (if you try to use the Data Range tab with pivot table data, Excel turns the chart into a pivot chart).

 

[Synergy Builders]

Thanks for the info it worked