Chart w/ multiple stacks

  • Thread starter Thread starter linda
  • Start date Start date
L

linda

I am trying to stack a chart with 6 series. I want to
have series 1 & 2 stacked, a new stack column for series
3&4, and another stack for series 5&6.

I have 12 months of data for 6 series
Jan Feb Mar Apr ...... Dec
S1 Region 1 '99 xxxx xxxx xxxx xxx ...... xxx
S2 Region 2 '99 xxxx xxxx xxxx xxx ...... xxx
S3 Region 1 '00 xxxx xxxx xxxx xxx ...... xxx
S4 Region 2 '01 xxxx xxxx xxxx xxx ...... xxx
S5 Region 1 '02 xxxx xxxx xxxx xxx ...... xxx
S6 Region 2 '02 xxxx xxxx xxxx xxx ...... xxx

The chart should have the 12 months along the bottom, with
three stacked charts (s1&s2, s3&s4, s5&s6)for each month.

I'm thinking I have to either customize a chart type, or
use the secondary axis... have tried unsuccessfully with
both options. Need an expert... Can you help?
 
Back
Top