Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Extra Data Row to Chart via Macro
I have a sheets with charts whose series, for example, go from A3 A11
(X) to B3 B11 (Y), another chart ranging from A6A11(x) C6C11 (Y) and so on.. Everytime I add a row of data I manually have to add the new point to each chart. Is is possible to select a chart and run a macro that would, for instance, substitute a number I choose in the data range for another one? That way I would be able to change the boundaries of each chart faster. Many thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Extra Data Row to Chart via Macro
Hi
It seems like you need the help of a dynamic chat. The chart updates itself when new data is added to the bottom of the range. Meaning you don't have to update the chart manually. A very good example of dynamic ranges can be found here. http://peltiertech.com/Excel/Charts/...umnChart1.html Good luck working it out. Marcus wrote: I have a sheets with charts whose series, for example, go from A3 A11 (X) to B3 B11 (Y), another chart ranging from A6A11(x) C6C11 (Y) and so on.. Everytime I add a row of data I manually have to add the new point to each chart. Is is possible to select a chart and run a macro that would, for instance, substitute a number I choose in the data range for another one? That way I would be able to change the boundaries of each chart faster. Many thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Extra Data Row to Chart via Macro
I was going to suggest this, but Marcus beat me to it. But there's also a
little utility I've made that will do a straight text substitution in the chart series formulas: http://peltiertech.com/Excel/Charts/ChgSrsFmla.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "marcus" wrote in message oups.com... Hi It seems like you need the help of a dynamic chat. The chart updates itself when new data is added to the bottom of the range. Meaning you don't have to update the chart manually. A very good example of dynamic ranges can be found here. http://peltiertech.com/Excel/Charts/...umnChart1.html Good luck working it out. Marcus wrote: I have a sheets with charts whose series, for example, go from A3 A11 (X) to B3 B11 (Y), another chart ranging from A6A11(x) C6C11 (Y) and so on.. Everytime I add a row of data I manually have to add the new point to each chart. Is is possible to select a chart and run a macro that would, for instance, substitute a number I choose in the data range for another one? That way I would be able to change the boundaries of each chart faster. Many thanks, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Extra Data Row to Chart via Macro
Your macro was EXACTLY what I was looking for!
Thank you very much! Jon Peltier wrote: I was going to suggest this, but Marcus beat me to it. But there's also a little utility I've made that will do a straight text substitution in the chart series formulas: http://peltiertech.com/Excel/Charts/ChgSrsFmla.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "marcus" wrote in message oups.com... Hi It seems like you need the help of a dynamic chat. The chart updates itself when new data is added to the bottom of the range. Meaning you don't have to update the chart manually. A very good example of dynamic ranges can be found here. http://peltiertech.com/Excel/Charts/...umnChart1.html Good luck working it out. Marcus wrote: I have a sheets with charts whose series, for example, go from A3 A11 (X) to B3 B11 (Y), another chart ranging from A6A11(x) C6C11 (Y) and so on.. Everytime I add a row of data I manually have to add the new point to each chart. Is is possible to select a chart and run a macro that would, for instance, substitute a number I choose in the data range for another one? That way I would be able to change the boundaries of each chart faster. Many thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding extra criteria | Excel Worksheet Functions | |||
Adding extra data to a chart | Charts and Charting in Excel | |||
Extra data plotted on chart | Charts and Charting in Excel | |||
Macro/Formula to extra data from certain rows | Excel Discussion (Misc queries) | |||
Adding data series to chart via macro | Charts and Charting in Excel |