Stacked cylinder issue

[MikeF]

Need to create a stacked cylinder [or column] chart from the table as follows:

Date PresentOutput Capacity
6/29/2010 560,634 727,641
7/1/2010 579,232 727,641
7/2/2010 613,200 727,641


Each capacity needs to show as 100% [easy, that works fine] and each Present
Output needs to be the correct percentage of the Capacity, ie 77%, 80%, 84%
respectively, "filling up" each cylinder appropriately.

A good analogy would be "How full is the cup?".

But when I build the stacked chart, PresentOutputs calc out at approx 41%,
43%, and 45% respectively.
This doesn't make sense of course, but perhaps I'm misunderstanding how this
specific chart should work.

Even if I actually use percentages as the data series, it presents the same
anomaly.

Have tried a few workarounds to fool it, but no joy.

Does anyone have the solution?

Thanx in advance.

- Mike

 

[Bernard Liengme]

To gain insight how the 100% stacked column works, make a chart with this
data
item....sold.....Instock
a........5.......5
b........1.......10
c.......25......100


If I read you correctly, use the first thee columns of the following to make
your chart
date.....Output....Capacity...Cap
29-Jun....560,634...148,409...727,641
01-Jul.....579,232...114,441...727,641
02-Jul.....613,200...727,641...727,641

The 148,409 in B2 is generated from =D2-B2
Don't' worry about the dates I use this format as it saves worrying about US
vs World formats
best wishes

 

[Bernard Liengme]

Opps, I slipped with the formula. Those values should be
date Output Capacity Cap
29-Jun 560,634 167,007 727,641
01-Jul 579,232 148,409 727,641
02-Jul 613,200 114,441 727,641

 

[MikeF]

Works GREAT, thanx Bernard!!

Opps, I slipped with the formula. Those values should be
date Output Capacity Cap
29-Jun 560,634 167,007 727,641
01-Jul 579,232 148,409 727,641
02-Jul 613,200 114,441 727,641


--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

Need to create a stacked cylinder [or column] chart from the table as
follows:

Date PresentOutput Capacity
6/29/2010 560,634 727,641
7/1/2010 579,232 727,641
7/2/2010 613,200 727,641


Each capacity needs to show as 100% [easy, that works fine] and each
Present
Output needs to be the correct percentage of the Capacity, ie 77%, 80%,
84%
respectively, "filling up" each cylinder appropriately.

A good analogy would be "How full is the cup?".

But when I build the stacked chart, PresentOutputs calc out at approx 41%,
43%, and 45% respectively.
This doesn't make sense of course, but perhaps I'm misunderstanding how
this
specific chart should work.

Even if I actually use percentages as the data series, it presents the
same
anomaly.

Have tried a few workarounds to fool it, but no joy.

Does anyone have the solution?

Thanx in advance.

- Mike

.