High / Low Bar Chart

[Guest]

I want to make a bar chart that shows high and low values
for a range. I have a database that looks like:

X Y Z
High 25 24 14
Low 10 11 8


How do I do this in Excel?

Thanks!

 

[Jon Peltier]

I've rearranged your data, and inserted a row with the span (the
difference between High and Low):

X Y Z
Low 10 11 8
Span 15 13 6
High 25 24 14

Keep the top left cell blank, and select the top three rows of this
range, omitting High. Make a stacked bar chart with two series, Low and
Span. Double click on the Low series, click on the Patterns tab, and
select None for Fill and Border.

- Jon