Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked chart with 2 series
I want to chart the following into a stacked bar chart
2007, Jan, Feb, Mar, A, 3, 7, 4 B, 5, 10, 6 C, 9, 12, 9 2006, Jan, Feb, Mar A, 2,5,3 B, 4, 8, 5 C, 8, 10,7 I want x to have Jan-Mar. Separate stacked bars for 2006 & 2007 years. Each bar should have at the bottom the "A" valule, then middle the "B" value, then top the "C" value. "A" will always be less than "B" which will always be less than "C". I have been able to manipulate the table to do something similar but the 2006 Jan bar is not side by side of the 2007 Jan bar. -- --coastal |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked chart with 2 series
So do you want clustered-stacked bars? Try one of these:
http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "coastal" wrote in message ... I want to chart the following into a stacked bar chart 2007, Jan, Feb, Mar, A, 3, 7, 4 B, 5, 10, 6 C, 9, 12, 9 2006, Jan, Feb, Mar A, 2,5,3 B, 4, 8, 5 C, 8, 10,7 I want x to have Jan-Mar. Separate stacked bars for 2006 & 2007 years. Each bar should have at the bottom the "A" valule, then middle the "B" value, then top the "C" value. "A" will always be less than "B" which will always be less than "C". I have been able to manipulate the table to do something similar but the 2006 Jan bar is not side by side of the 2007 Jan bar. -- --coastal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data series label in Stacked Chart | Charts and Charting in Excel | |||
how do I add series lines to a an excel stacked chart | Charts and Charting in Excel | |||
Combine stacked column and line chart w/series lines | Charts and Charting in Excel | |||
How do I set up a stacked chart with different series for each bar | Charts and Charting in Excel | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |