I've spent the last day searching on Google and YouTube. The closest I found was a tutorial on stacked bar charts, but it does not completely answer my question.
I'm trying to do the following: Conceptual Excel Chart
For example, let's say I have the following:
- Radio 1 (Blue) - 200 to 300
- Radio 1 (Red) - 350 to 400
- Radio 2 - 300 to 400
What I would like to show are the two entries for Radio 1 and Radio 2 on the y-axis. On the chart, I would like a bar showing the 200 to 300 range for Radio 1 (Blue) and the 350 to 400 range for Radio 1 (Red). Both entries should be aligned to the Radio 1 label. Preferably, the Blue bar should have "Blue" label and the Red bar should have "Red" label. Below Radio 1, I want a Radio 2 entry that shows a bar from 300 to 400. The bars should be aligned to the x-axis.
My Excel version is Version 1705 (Build 8201.2193).
I would appreciate any help and additional tips you can throw my way.