Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't get data from a web page to chart in excel. Any solutions? | Charts and Charting in Excel | |||
Can't get data from a web page to chart in excel. Any solutions? | Excel Discussion (Misc queries) | |||
Adding Data Information to a Chart | Charts and Charting in Excel | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |