If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Stacked cylinder issue
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 |
#2
|
|||
|
|||
Stacked cylinder issue
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 V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "MikeF" wrote in message ... 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 |
#3
|
|||
|
|||
Stacked cylinder issue
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 "MikeF" wrote in message ... 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 |
#4
|
|||
|
|||
Stacked cylinder issue
Works GREAT, thanx Bernard!!
"Bernard Liengme" wrote: 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 "MikeF" wrote in message ... 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 . |
Thread Tools | |
Display Modes | |
|
|