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

  • Thread starter Thread starter JHB
  • Start date Start date
J

JHB

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
 
Back
Top