Bar charts

[ehume]

I would like to present some data in a compound bar chart like this one, where the data need to be seen together, but are not part of a whole. In my case, I'm presenting noise overlaid on temp-over-ambient. I don't want to hand do them because I have a hundred data pairs.

I have Excel 2007, but its compound bar charts assume the parts add up to a whole.

Any ideas?

Thanks

 

[MagnusTheBrewer]

Can't that simply be done with Format?

 

[Ken g6]

GnuPlot? Evidently they call it a "stacked histogram".

 

[Snapster]

Perfectly possible in Excel

Just use a secondary axis and fix the min/max axis ticks.

 

[ehume]

Sounds interesting. What is a secondary axis?

Ah. Found it. Thank you very much. Just what I needed.

Stacked histogram is like other stacked things: it assumed cumulative data, with contributions. Your immigration example takes apart a sum and breaks it into constituent parts. What I needed was a way to simultaneously show sound pressure level vs temperature over ambient. The secondary axis concept does that.

Thank you both for your assistance.