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

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