LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Stacked Charts Comparing 2 Years On 2 Different Sheets

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
100% stacked column with multiple years (3) and areas (7) Miles04 Charts and Charting in Excel 1 October 3rd 08 11:40 PM
Stacked Column 2 sets of data for 2 years Jan Charts and Charting in Excel 3 February 21st 07 04:36 AM
comparing test scores over a few years Justin Excel Discussion (Misc queries) 0 July 3rd 06 01:39 PM
Excel Stacked Column Graph (3 Divisions for 3 Years) Brian Charts and Charting in Excel 5 April 20th 06 05:22 PM
Chart comparing months between 2 years Debra Charts and Charting in Excel 3 April 11th 06 11:11 PM


All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"