High / Low Bar Chart

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

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!
 
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
 
Back
Top