Stacked Chart

[Smiley]

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???

 

[ShaneDevenshire]

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

 

[ShaneDevenshire]

Hi,

Two other things you can do to fancy the chart up a bit:

1. Insert blank columns in the spreadsheet between the A data and B data
and C data so your data looks like:
B C D E F G
H I

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

2. Right click any series on the chart and choose Format Data Series and on
the Options tab, set Gap width to 0.

If this helps, please click the Yes button.