| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart: Use range name for source data
Is it possible to specify range name for source data when creating
chart? Shinya |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Chart: Use range name for source data
Shinya -
You need to preface the range name with the worksheet name. =Sheet1!MyRange If you use this on the Data Range tab, Excel converts it to the regular address, so it's not truly dynamic. If you use it on the Series tab for every series, the range names are remembered, and the chart adjusts as the ranges change in size. More info: http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ sk wrote: Is it possible to specify range name for source data when creating chart? Shinya |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Chart: Use range name for source data
Jon
Thank you for the greate tip. Shinya "Jon Peltier" wrote in message ... Shinya - You need to preface the range name with the worksheet name. =Sheet1!MyRange If you use this on the Data Range tab, Excel converts it to the regular address, so it's not truly dynamic. If you use it on the Series tab for every series, the range names are remembered, and the chart adjusts as the ranges change in size. More info: http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ sk wrote: Is it possible to specify range name for source data when creating chart? Shinya |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a named range as a data source for a chart | Charts and Charting in Excel | |||
| Using a named range as a data source for a chart | Excel Worksheet Functions | |||
| Using a Named Range for Data Source In A Chart | Charts and Charting in Excel | |||
| Chart source data range | Excel Programming | |||
| change chart source from range to raw data | Excel Programming | |||
![sk[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
