BAR CHARTS-DISPLAYING A WHOLE BAR AND A STACKED BAR ON THE SAME GRAPH

[Moo]

I'm trying to create a bar chart from 3 different data columns. What
I'm looking to do is use the 1st column as one whole bar, but to put
columns 2 and 3 into one stacked bar. Is there any way I can do this
on the same chart?

 

[jeff]

Hi,

I'm sure someone has a better way, but you might try
manipulating your data from this:
Bar ---stacked-
25 5 9
35 6 8
45 7 5
12 1 7
15 2 13
60 3 4
3 4 11

to:

--stacked---
25 0 <- shows as solid bar
5 9 <- shows as stacked
35 0
6 8
45 0
7 5
12 0
1 7
15 0
2 13
60 0
3 4
3 0
4 11
45 0
5 22

Hope this helps.
jeff