Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
John
 
Posts: n/a
Default combination clustered column and stacked bar chart

I have data concerning the repair turn-around for three products over several
months. There are two components to the turn-around time for any item, i.e.,
actual labor time and wait time. I want to graph this as a clustered column,
each cluster representing the data for a given month and each bar in a
cluster representing one of the products. Now for the tricky part: I want
each of the bars to be stacked showing the relationship between the actual
labor time and the wait time.
  #2   Report Post  
John Mansfield
 
Posts: n/a
Default

John,

I don't know if I'm fully understanding what you want. Possibly these two
examples can help:

http://www.pdbook.com/index.php/exce..._column_chart/

http://www.pdbook.com/index.php/exce..._column_chart/

If this doesn't help, please post back with more specifics.

----
Regards,
John Mansfield
http://www.pdbook.com


"John" wrote:

I have data concerning the repair turn-around for three products over several
months. There are two components to the turn-around time for any item, i.e.,
actual labor time and wait time. I want to graph this as a clustered column,
each cluster representing the data for a given month and each bar in a
cluster representing one of the products. Now for the tricky part: I want
each of the bars to be stacked showing the relationship between the actual
labor time and the wait time.

  #3   Report Post  
John
 
Posts: n/a
Default

John,

The technique illustrated in the links you provided may work if nothing else
presents itself. What I will have to do is use the sum of the actual labor
and wait time as the value for the bar that ends up 'behind' That way, the
short bar in front would represent actual labor and the visible part of the
taller bar behind would represent the wait time, just as I want. Thanks for
the help, John. I'll let you know if this actually works.

Regards,
John Reece

"John Mansfield" wrote:

John,

I don't know if I'm fully understanding what you want. Possibly these two
examples can help:

http://www.pdbook.com/index.php/exce..._column_chart/

http://www.pdbook.com/index.php/exce..._column_chart/

If this doesn't help, please post back with more specifics.

----
Regards,
John Mansfield
http://www.pdbook.com


"John" wrote:

I have data concerning the repair turn-around for three products over several
months. There are two components to the turn-around time for any item, i.e.,
actual labor time and wait time. I want to graph this as a clustered column,
each cluster representing the data for a given month and each bar in a
cluster representing one of the products. Now for the tricky part: I want
each of the bars to be stacked showing the relationship between the actual
labor time and the wait time.

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
Stacked column and column combo chart KG Charts and Charting in Excel 5 March 16th 05 03:01 PM
To create a stacked column chart and group the stacked bars togeth Jacqueline Charts and Charting in Excel 1 February 18th 05 12:05 AM
combination of stacked and clustered column Grigori Margolin Charts and Charting in Excel 2 January 23rd 05 08:27 PM
Clustered column chart with stacked coumns Dave Charts and Charting in Excel 1 January 4th 05 11:40 PM
Making Special "Stacked Column" Chart Chaplain Doug Charts and Charting in Excel 3 December 10th 04 05:31 PM


All times are GMT +1. The time now is 04:41 PM.

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

About Us

"It's about Microsoft Excel"