split bar chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a bar chart using the following data:

Column1 = 2 (value inside cell)
Column2 = 3 (value inside cell)
Coumn3 = 5 (=column1 + column2)

Here's the layout I'm looking for:

bar1 would start at 0(zero) and stop at 2
bar2 would start at 3 and stop at 5 (nothing would show below 3 for this bar)

It's pretty much a stacked bar graph but each "stack" would be in its own
column.

Thanks!
 
I'm actually trying to make a stacked graph to display the stacks as floating
bars, each stack in its own colum. I'm not sure if I can explain it without
visual.
 
I found what I was looking for under Format Data Series > Options.

All I needed to do was create a stacked bar chart and make the overlap
option = 0.

Thanks anyways!
 
Back
Top