Comparative Histogram

[Jo Beth]

I am trying to create a "comparative" histogram to show the amount of songs
on an ipod for men vs women. Can't figure out how to get this to work.

 

[Jon Peltier]

A better chart type might be a dot plot:

http://peltiertech.com/Excel/Charts/DotPlot.html

Sometimes people use tornado charts:

http://peltiertech.com/Excel/Charts/tornadochart.html

but it's harder than it looks to compare bars that go in opposite
directions.

- Jon