Chart help...

[Hornet_MT]

Apologies if this a dumb question (first time posting on these
boards)...

I have a compound column chart and I want to add another series, except
I want the other series to sit next to the compound column, i.e.

1
1 3
1 3
1 3
2 3
2 3
2 3
------

I can get the 3rd series to appear as a line chart with no problems,
but whenever I try to turn it into a bar chart it moves into the
compound column!!

(ps I am trying to show Budget P&L next Actual P&L, where the Actuals
is broken down into types)

Is this possible or do I have to live with no extra column?

 

[robert111]

4 7 6 6 1 12
3 8 2
2 4 3
5 5 4


Enter your data as above, select all of it and create stacked bar
chart. The 7, 6 and 12 appear as single bars next to the stacks.

 

[robert111]

sorry the paste didnt work - enter data as


4 7 5 6 8 9
3 4 6
2 3 4
1 2 2

select all data and make stacked bar chart, the 7, 6 and 9 will appea
as single bars next to the stack