range of value

[deb]

I want to have a range of values for each data point -
example:

Item A I want the top of the bar to be at 115,000 and the
bottom at 85,000, Item B I want the top of the bar to be
130,000 and the bottom to be 90,000 - etc. How do I do
that?

 

[Jon Peltier]

Deb -

You want a floating column chart. Set up your data like this:

A B
Bottom 85000 90000
Top 30000 40000

The row 'Top' is really the difference between your top and bottom
values. Make a stacked column chart (bar charts are horizontal in Excel
lingo), and the bottom columns will support the top columns. Double
click the bottom series, click on the Patterns tab, and select None for
Border and Area.

- Jon