chart based on data ranges tom ossieur 29.09.2006 14:31:02 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

Re: chart based on data ranges Andy Pope <andy[ at ]andypope.info> 30.09.2006 11:36:35 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/FloatingColumns.html Cheers Andy tom ossieur wrote: [Quoted Text] > 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