| 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 | |||
Linear Mode
