Automatic Chart Updating
Posted on 2011-09-21
I am trying to insert a new line of data in a defined chart area called "CompletionByTheArea". "CompletionByTheArea" is a defined name on Sheet1.
Problem is that when I insert a row, expanding the range by one, the chart does not see the new row, even though the new inserted row is contained inside of the defined "CompletionByTheArea" range.
The only way I get the new row of data into the chart is to do another chart>select data and type over the chart data range each time, ='Sheet1'!CompletionbytheArea Excel macro recorder did not do this.
Have I have a chart named Chart1.
How in VBA would I redefine the chart range so that it updates the chart, and includes my new row? without having to redefine it everytime? -R-