Help needed with stacked column chart

[soph12081]

Hello

Hopefully somebody can help..

I would like to be able to create a stacked column chart with two different sets of data in there.

I have two values, say 79% and 96%, and would like them displayed in the same column so one colour finishes at 79% and then the second colour continues to 96%. is this possible?

Because they are percentages I only seem to be able to find a stacked column chart that adds the two percentages up resulting in a figure above 100%.

Any ideas would be great?

Thanks in advance.

 

[seguin85]

You would need to add an additional column that would subtract 79% from 96%, then graph the 79% and the 17%.

	A	B	C
1	79	96	17
2	20	45	25
3	88	95	7

<tbody>
</tbody>

So graph columns A and C as opposed to A and B.