chart based on data ranges
 

Hi,

Given a table as follows:

a b
2000 5000/6000 3500/4500
2001 5000/6000 4000/4500
2003 6000/7000 5000/6000
2004 8000/9000 5000/5500

Data are "data ranges" instead of data
(e.g. a ranging from 5000 to 6000 in year 2000).

Guess the ranges have to split out over 2 cells per cell? Or is it possible
to make a graph straight from these data?

Thanks!

tom

chart based on data ranges
 

Hi,

You will need to break the data out to 2 cells as currently the chart
will treat the value as text.

This page on floating columns by Jon Peltier may help.
http://peltiertech.com/Excel/Charts/...ngColumns.html

Cheers
Andy

tom ossieur wrote:
Hi,

Given a table as follows:

a b
2000 5000/6000 3500/4500
2001 5000/6000 4000/4500
2003 6000/7000 5000/6000
2004 8000/9000 5000/5500

Data are "data ranges" instead of data
(e.g. a ranging from 5000 to 6000 in year 2000).

Guess the ranges have to split out over 2 cells per cell? Or is it possible
to make a graph straight from these data?

Thanks!

tom




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info