Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 9th 09, 08:41 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 66
Default 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   Report Post  
Old February 9th 09, 08:49 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 2,722
Default 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   Report Post  
Old February 9th 09, 10:50 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 66
Default 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
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
Excel 2003 - Combination chart: Stacked Column + Stacked Column Robyda Charts and Charting in Excel 4 August 24th 08 03:16 PM
Combination Stacked Bar with Single Bar Chart CB Charts and Charting in Excel 2 August 30th 07 08:45 AM
How do I combine stacked column and single column graphs? Alf Excel Discussion (Misc queries) 0 February 24th 06 12:29 AM
How do you combine a stacked column and single column graph? Charlotte C Charts and Charting in Excel 1 December 3rd 05 01:04 PM
To create a stacked column chart and group the stacked bars togeth Jacqueline Charts and Charting in Excel 1 February 17th 05 11:05 PM


All times are GMT +1. The time now is 03:50 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017