| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Variable size of chart
I would like to write some VBA code that can use a chart, and control the
range of the source data from the code, so avoid manually changing anything. Is this possible? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Variable size of chart
You don't necessarily need code if you make use of dynamic names as the
chart series data: http://peltiertech.com/Excel/Charts/...umnChart1.html http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Derek Locke" <Derek wrote in message ... I would like to write some VBA code that can use a chart, and control the range of the source data from the code, so avoid manually changing anything. Is this possible? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Variable size of chart
Many thanks - Derek Locke
"Jon Peltier" wrote: You don't necessarily need code if you make use of dynamic names as the chart series data: http://peltiertech.com/Excel/Charts/...umnChart1.html http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Derek Locke" <Derek wrote in message ... I would like to write some VBA code that can use a chart, and control the range of the source data from the code, so avoid manually changing anything. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VB count word occurence in variable size sheet | Excel Worksheet Functions | |||
| defining a variable-size worksheet area for charting | Excel Worksheet Functions | |||
| defining a variable-size worksheet area for copying & pasting | Excel Worksheet Functions | |||
| Populating a summary of variable size. | Excel Discussion (Misc queries) | |||
| Chart with both X & Y variable | Charts and Charting in Excel | |||
Linear Mode
