Multi data charts

G

Guest

I want to build a chart which shows the year on the horizontal axis and the
totals on the vertical axis. The tough part is there are six diiferent data
series for each year that when summed give the total for the year. I want to
show one bar for each year with each individual data point stacked on top of
each other to show the total bar size. I've done it before with 2 series but
can't get it to work with six. Help!
 
G

Guest

If any of your numbers are negative, the stacked bar chart won't work
properly. you have to play with the numbers ot get them to total where you
want them to.
if none are negative, what are you getting that is wrong?
 

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

Stacked Data Charts from Excel 2
How to chart months by financial year 0
Combining multiple Stacked Charts 1
Superimposing Charts 2
2 axis chart stacked bar next to bar with line 1
superimposed 3-D stacked area charts 2
Stacked bar charts 1
Combining a regular bar chart and stacked bar chart 3

Top