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