Multiple data in X-Axis

[Alex]

Hi everyone,

I'm trying to chart the following spreadsheet layout:

Expr2 FinancialClass SumOfTxnAmount
January, 2003 M $145
January, 2003 C $1432
January, 2003 P $23
January, 2003 S $432
January, 2003 B $2432
January, 2003 F $321
February, 2003 P $321
February, 2003 M $542
February, 2003 C $542
February, 2003 S $987
February, 2003 HMO $567
March, 2003 M $56
March, 2003 C $3456
March, 2003 B $526
March, 2003 P $1665
March, 2003 S $363
March, 2003 HMO $245
March, 2003 PPO $248
March, 2003 F $166

And I need the X Axis of the bar chart to look something like this:

| | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | |
M C B P S HMO PPO M C B P S HMO PPO M C B P S HMO PPO
January 2003 February 2003 March 2003

But when I attempt to create the chart, it instead puts the month on
each colume, so each month is listed 7 times and horizontal,
overlapping and making basically a black bar along the bottom as the
letters merge.

I'm using Excel XP... any suggestions? Thanks,

Alex.

 

[Andy Pope]

Hi Alex,

Assuming your data is in cells A1:C20 then make these mods to help Excel
create your chart.
Remove Expr2 from A1
Remove FinancialClass from B1
Remove all but the first occurance of each unique month,
A3:A7 , A9:A12 , A14:A20

Now select A1:C20 and create a column chart.
Make sure the values in column C are not text but true numbers.

Hi everyone,

I'm trying to chart the following spreadsheet layout:

Expr2 FinancialClass SumOfTxnAmount
January, 2003 M $145
January, 2003 C $1432
January, 2003 P $23
January, 2003 S $432
January, 2003 B $2432
January, 2003 F $321
February, 2003 P $321
February, 2003 M $542
February, 2003 C $542
February, 2003 S $987
February, 2003 HMO $567
March, 2003 M $56
March, 2003 C $3456
March, 2003 B $526
March, 2003 P $1665
March, 2003 S $363
March, 2003 HMO $245
March, 2003 PPO $248
March, 2003 F $166

And I need the X Axis of the bar chart to look something like this:

| | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | | | | |
M C B P S HMO PPO M C B P S HMO PPO M C B P S HMO PPO
January 2003 February 2003 March 2003

But when I attempt to create the chart, it instead puts the month on
each colume, so each month is listed 7 times and horizontal,
overlapping and making basically a black bar along the bottom as the
letters merge.

I'm using Excel XP... any suggestions? Thanks,

Alex.

--

Cheers
Andy

http://www.andypope.info

 

[Alex]

Hi Andy,

I ran across your site not long after posting my message, and your
examples of doing just this helped. Thanks! I also learned a TON
from the other samples, so thanks for the awesome page.

Alex.

 

[Andy Pope]

Hi Alex,

Glad it help and thanks for the comments.

Hi Andy,

I ran across your site not long after posting my message, and your
examples of doing just this helped. Thanks! I also learned a TON
from the other samples, so thanks for the awesome page.

Alex.

--

Cheers
Andy

http://www.andypope.info