Stacked Charts Comparing 2 Years On 2 Different Sheets

J

jstidsto

Hi,
I have an excel worksheet that has sheet 1 with 2008 data and sheet 2 with
2009 data. The data is laid out as follows on both sheets but with
appropriate year's data:
Jan Feb Mar Apr
TOTAL MEMBERSHIP AGES <65
TOTAL MEMBERSHIP AGES 65-67
TOTAL MEMBERSHIP AGES 65-68

What I am trying to do is stack the different age groups in one bar and
compare 2008 Jan results to 2009 Jan results and so on for each month. So
within each month label on the Y axis (I believe) (bottom axis) have two
stacked bars one for 2008 and the other with 2009 data. This to repeat for
each month showing both years bars with stacked data above.
 

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

sideways stacked bar charts with line series on the same axis 0
Combination bar/stacked charts 1
multiple columns into one column and autofill(?) question 1
Stacked Color Charts 1
Stacked Column Charts 2
Date Format + Graph 2
Data From Various Sheets 0
Stacked Data Charts from Excel 2

Top