Prev: scale a single series (divide each datapoint by X)
Next: Specialty charts
From: JHB on 30 Nov 2009 16:23
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
From: Jon Peltier on 1 Dec 2009 19:55
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
 | 
Pages: 1
Prev: scale a single series (divide each datapoint by X)
Next: Specialty charts