Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked column with additional single bar chart
I am wondering if it is possible to create a stacked column chart and
alsohave a single bar next to the stacked bar. What I am looking to do is show employee count or pieces completed 75% per month and then the other 25% per month of the stacked column. The second bar would be the team average. i currently have three columns of data, pieces completed per month (75 % counts) and second pieces completed per month (25% counts) and final third column the team average. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked column with additional single bar chart
See this site:
http://people.stfx.ca/bliengme/ExcelTips/Columns.htm or maybe this one: http://peltiertech.com/Excel/ChartsH...sterStack.html -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jen_T" wrote: I am wondering if it is possible to create a stacked column chart and alsohave a single bar next to the stacked bar. What I am looking to do is show employee count or pieces completed 75% per month and then the other 25% per month of the stacked column. The second bar would be the team average. i currently have three columns of data, pieces completed per month (75 % counts) and second pieces completed per month (25% counts) and final third column the team average. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked column with additional single bar chart
Thank you Luke, that was helpful,
I did add two other columns to the chart and made the chart typeline chart. Is there a way to flip flop the Y and X value axis. Currently my Y axis is percentage and the X is General, like to flip flop. "Luke M" wrote: See this site: http://people.stfx.ca/bliengme/ExcelTips/Columns.htm or maybe this one: http://peltiertech.com/Excel/ChartsH...sterStack.html -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jen_T" wrote: I am wondering if it is possible to create a stacked column chart and alsohave a single bar next to the stacked bar. What I am looking to do is show employee count or pieces completed 75% per month and then the other 25% per month of the stacked column. The second bar would be the team average. i currently have three columns of data, pieces completed per month (75 % counts) and second pieces completed per month (25% counts) and final third column the team average. |
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 | |||
Combination Stacked Bar with Single Bar Chart | Charts and Charting in Excel | |||
How do I combine stacked column and single column graphs? | Excel Discussion (Misc queries) | |||
How do you combine a stacked column and single column graph? | Charts and Charting in Excel | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |