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

D

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,
 
B

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.
 
D

Dream

Thanks alot

bman said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart showing ranges of prices of different items? 3
Chart with various Y value ranges 1
Input a Value to Lookup the Data Series for a Chart 5
Bar Chart Axis Labels 5
charting variable line data 1
Excel Chart question using two y axes 2
Graph to create a Gant Chart 1
CHART HELP Percent of Increase 2

Top