Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I get multiple stacked bars per entry on a stacked bar chart? | Excel Discussion (Misc queries) | |||
?make a combo chart with 1 stacked bar and 1 not stacked, + show t | Charts and Charting in Excel | |||
How do I create a one cylinder graph? | Charts and Charting in Excel | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |