Hi,

Rearrange your data to look like this

A B C
Q1 Q2 Q1 Q2 Q1 Q2
Oranges 3 5 2 2 1 1
Apples 4 4 3 4 2 3

Where A, B and C are not column letters but you categories, Then do a
stacked column.

If this helps, please click the Yes button
--
Thanks,
Shane Devenshire


"Smiley" wrote:

Hi, I am wanting to produce a q-o-q analysis with stacked charts but I cant
seem to get them to line up properly.
Q1 Q1 Q2 Q2
A 4 3 4 5
B 3 2 4 2
C 2 1 3 1

So using the numbers above as an eg, I want one stacked Q1 graph for 'A'
using the two Q1 figures and one stacked Q2 graph for 'A'. Ideally the Q1
and Q2 stacked bars would be side by side, then a gap and the same thing for
B, C etc.

Can anyone help???