(Msg. 1) Posted: Mon Nov 10, 2008 5:23 am
Post subject: Stacked Chart Archived from groups: microsoft>public>excel>charting (more info?)
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.
(Msg. 2) Posted: Mon Nov 10, 2008 7:14 am
Post subject: RE: Stacked Chart [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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???
(Msg. 3) Posted: Mon Nov 10, 2008 9:05 am
Post subject: RE: Stacked Chart [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
--
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???
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office