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.

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.

Alex wrote:

> 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

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 <(E-Mail Removed)> wrote in message news:<#(E-Mail Removed)>...
> 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.
>
> Alex wrote:
>
> > 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.

Hi Alex,

Glad it help and thanks for the comments.

Alex wrote:

> 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 <(E-Mail Removed)> wrote in message news:<#(E-Mail Removed)>...
>
>>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.
>>
>>Alex wrote:
>>
>>
>>>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