PC Review


Reply
Thread Tools Rate Thread

combination clustered column and stacked bar chart

 
 
=?Utf-8?B?Sm9obg==?=
Guest
Posts: n/a
 
      19th Apr 2005
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 With Quote
 
 
 
 
=?Utf-8?B?Sm9obiBNYW5zZmllbGQ=?=
Guest
Posts: n/a
 
      19th Apr 2005
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 With Quote
 
=?Utf-8?B?Sm9obg==?=
Guest
Posts: n/a
 
      19th Apr 2005
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clustered and Stacked Column Chart Cassie Microsoft Excel Misc 2 19th May 2009 01:23 AM
Clustered and Stacked Column Chart Cassie Microsoft Excel Misc 0 18th May 2009 03:07 PM
Excel 2003 - Combination chart: Stacked Column + Stacked Column Robyda Microsoft Excel Charting 3 24th Aug 2008 03:16 PM
how to create a clustered, 100% stacked combination chart =?Utf-8?B?S2VyaSBpbiBWZXJtb250?= Microsoft Excel Charting 1 3rd Jun 2006 06:37 PM
combination of stacked and clustered column Grigori Margolin Microsoft Excel Charting 2 23rd Jan 2005 07:27 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:22 PM.