Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Two Data Sets: Stacked Column Chart
How do I show two years side-by-side in a stacked column chart? I want to
compare two "stacked" columns each month (one for each year). I can create one showing each month for ONE year but I want to add another year in another stacked column for each month. Can this be done? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Two Data Sets: Stacked Column Chart
Yes, it can be done. It just takes some careful arrangement of data. See Jon
Peltier's excellent site on charting: http://peltiertech.com/WordPress/clu...column-charts/ (depending on your browser, you may need to scroll down a bit to get to beginning of article) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Rainmaker" wrote: How do I show two years side-by-side in a stacked column chart? I want to compare two "stacked" columns each month (one for each year). I can create one showing each month for ONE year but I want to add another year in another stacked column for each month. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - Combination chart: Stacked Column + Stacked Column | Charts and Charting in Excel | |||
Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
Stacked Column 2 sets of data for 2 years | Charts and Charting in Excel | |||
Stacked column chart wit more than one column in a data point | Charts and Charting in Excel | |||
How do I group multiple sets of data for stacked bar chart? | Charts and Charting in Excel |