Automatic updating excel chart dating etiquitte from the fifties
For instance, Excel automatically updates a chart when a change is made to the chart data.
Follow these steps: Now you'll have an opportunity to capture a snapshot of your chart data before the chart is updated.
For instance, you may have some data that represents a time period, such as 11/1 through 11/13, and you create a chart based on those dates.
If you add new data to the end of the range (after 11/13), then Excel doesn't know you want those items added to the chart.
Wouldn’t it be great to be able to link the axis scale parameters to values or, even better, formulas in the worksheet? There are a few pieces you need to make this technique work. Click on the left hand dropdown at the top of this module, and select Private Sub Worksheet_Change(By Val Target As Range) With Active Sheet.
You need a chart, a set of values for the scaling parameters, and some VBA code to change the axis scales.