| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chart using named range
Hello,
How can I plot a chart where the data points to a "named range"? If the name of my range is "test", what is the correct syntax to put in the data tab...I tried: =test ="test" ......but none of them seemed to work. Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Chart using named range
Hi,
You would need to include the sheet or workbook =Sheet1!Test You will find plenty of information in these pages http://peltiertech.com/Excel/Charts/Dynamics.html Cheers Andy Tigerxxx wrote: Hello, How can I plot a chart where the data points to a "named range"? If the name of my range is "test", what is the correct syntax to put in the data tab...I tried: =test ="test" .....but none of them seemed to work. Thank you -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need help using named range in chart | Charts and Charting in Excel | |||
| Using a named range as a data source for a chart | Charts and Charting in Excel | |||
| Can't chart dynamic named range?? | Charts and Charting in Excel | |||
| Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
Linear Mode
