Chart w/ multiple stacks

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

linda

Sorry, I just noted that I should have sent this to
the "Chart" area of Excel.

.....Linda
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top