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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display Info in Data Table That is Not Charted? 1
Access Combination Chart Types Access 2010 0
Display Data Table in chart but don't show plot area 2
Graph Line Width ? 1
Combination Line and Bar Graph 1
Format Data Table 3
Stack bar charts with positive and negative numbers 2
graph variance components when 1 is negative 4

Back
Top