Column within a column HELP needed

[HugoRune]

Hi Guys,

I'm trying to represent a proportion of a column made up of a second measure on a normal Column Chart. For example if a product was offered 70% of the time and 85% of these products were relevant, I would have 1 single column with a value of 70% and then 85% of this column would be one colour and the other 15% would be another.

Any ideas?

Cheers

 

[Andrew Poulsom]

Set out your data like this:

<TABLE style="WIDTH: 144pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=192 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=64 height=17>Name</TD><TD class=xl23 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Val1</TD><TD class=xl23 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=64>Val2</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>Prod1</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:fmla="=70%*85%" x:num="0.59499999999999997">59.500%</TD><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:fmla="=70%*15%" x:num="0.105">10.500%</TD></TR></TBODY></TABLE>

and create a Stacked Column chart.

 

[HugoRune]

Given that another go but it just stacks the 2 values on top of each other. I need it to work almost like a Pie chart so that the secondary value is the percentage of the total of the primary value.

 

[Andrew Poulsom]

For me the total of the stack is 70%, of which the first block is 59.5% (85% of 70%) and the second block is 10.5% (15% of 70%). You may need to adjust the y axis scale so that it starts at zero.

 

[HugoRune]

Thanks for the help. Think I got it