How to create a chart showing ranges of prices of different produc

[Dream]

Hi all,

I very much appreciate your help. I am trying to create a chart such as the
one in the following link:

http://earthtrends.wri.org/images/ethanol_production_cost_small.jpg

It shows on the Y-axis different items. On the X-axis, the price in USD
0..1...2...3...4...5...6...7...and so on.

Than, for each product I need to plot its range of prices. For example, for
item 1, its price ranges from 3 to 5 dollar. so it should be a horizontal
line or bar extending from 3 to 5.

Could you please explain to me how to do it? By the way, Any idea what these
types of charts are called?

Thanks in advance,

 

[מיכ×ל (מיקי) ×בידן]

I would suggest something like that:
http://img697.imageshack.us/img697/6720/nonameb.png
Micky

 

[JudithJubilee]

Hi Dream,

They are called Floating Column charts

Check out this link
http://peltiertech.com/Excel/Charts/FloatingColumns.html

 

[Luke M]

I believe this would be a floating bar chart. You can create it by having a
stacked bar chart, with a dummy series that is formatted to have no fill/no
line.

Check out Jon's article for a quick example of how-to:
http://peltiertech.com/Excel/Charts/FloatingColumns.html

 

[Luke M]

What you are looking for is called a floating bar/column chart. Check out
Jon's site for a how-to:
http://peltiertech.com/Excel/Charts/FloatingColumns.html

 

[bman]

It's called a Hi-Low Chart. Look under the stocks types of charts, you can
take out the close series to just have the high and low. Also there is a
Floating Bar type chart under Custom Types, this is probably what you are
looking for. The orientation is more suited to your example. Looks pretty
self explanatory there.

 

[Dream]

Thank you for your post it is great and worked.

I would suggest something like that:
http://img697.imageshack.us/img697/6720/nonameb.png
Micky

 

[Dream]

Thank you.

Hi Dream,

They are called Floating Column charts

Check out this link
http://peltiertech.com/Excel/Charts/FloatingColumns.html

 

[Dream]

Thank you.

What you are looking for is called a floating bar/column chart. Check out
Jon's site for a how-to:
http://peltiertech.com/Excel/Charts/FloatingColumns.html
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

 

[Dream]

Thanks alot

It's called a Hi-Low Chart. Look under the stocks types of charts, you can
take out the close series to just have the high and low. Also there is a
Floating Bar type chart under Custom Types, this is probably what you are
looking for. The orientation is more suited to your example. Looks pretty
self explanatory there.