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/et...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


"Dream" wrote:

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/et...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,

Hi Dream,

They are called Floating Column charts

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

--
Hope this helps


"Dream" wrote:

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/et...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 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/...ngColumns.html

--
Best Regards,

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


"Dream" wrote:

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/et...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,

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/...ngColumns.html
--
Best Regards,

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


"Dream" wrote:

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/et...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,

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" wrote:

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/et...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,

Thank you for your post it is great and worked.

"מיכ�ל (מיקי) �בידן" wrote:

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


"Dream" wrote:

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/et...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,

Thank you.

"JudithJubilee" wrote:

Hi Dream,

They are called Floating Column charts

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

--
Hope this helps


"Dream" wrote:

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/et...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,

Thank you.

"Luke M" wrote:

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/...ngColumns.html
--
Best Regards,

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


"Dream" wrote:

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/et...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,

Thanks alot

"bman" wrote:

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" wrote:

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/et...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,