Totals in the data table but not in the graph / chart
 

I am graphing data that consists of 4 parts and over 5 years. I'm using a
stacked bar or an area chart and I do not want the totals to be charted. I
do however, want the totals (both by the year and the 4 parts) or across the
bottom and to the far right of the data table. I've chosen to have the data
table under the graph. I can easily put the totals into excel but then it
graphs the totals (which doubles everything). If I do not include the total
when I choose the graph the graph simply leaves them out with no space to add
them in...

JHB

Totals in the data table but not in the graph / chart
 

Graph the total, hide the total series (no lines, markers, border,
fill), and manually adjust the axis scale.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



JHB wrote:
I am graphing data that consists of 4 parts and over 5 years. I'm using a
stacked bar or an area chart and I do not want the totals to be charted. I
do however, want the totals (both by the year and the 4 parts) or across the
bottom and to the far right of the data table. I've chosen to have the data
table under the graph. I can easily put the totals into excel but then it
graphs the totals (which doubles everything). If I do not include the total
when I choose the graph the graph simply leaves them out with no space to add
them in...

JHB