Self updating excel graphs
There is no need to log in to collect data, nor to transcribe information from update emails.
Prices and ordering: subscriptions cost 12 per reported station per year with a 60 fixed charge per order (which applies both to initial setup and subsequent renewals).
It also took advantage of a trick using the category axis of an area (or line or column) chart: when used as a date axis, points that have the same date are plotted on the same vertical line, which allows adjacent colored areas to be separated by vertical as well as horizontal lines.
To fill under or between XY series, we’ll make use of this same approach: XY data on primary axes, Area data on secondary axes, with a secondary date axis.
Wouldn’t it be great to be able to link the axis scale parameters to values or, even better, formulas in the worksheet? If you want a ready-to-use solution, try Tushar Mehta’s Auto Chart Manager add-in, available as a free download at You can write the entire procedure yourself, but it’s easier and more reliable to let the VB Editor start it for you.
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.
Supposing you have created a chart to track the daily sales based on a range of data in your workbook.
But you need to change or edit the number of the data every day, in this case, you have to update the chart manually so it includes the new data.
This example can be expanded to include secondary axes, or to change other charts as well.
You can let Excel scale the axes automatically; when the charted values change, Excel updates the scales the way it thinks they fit best. Or you could assign the code to a button in the worksheet. A more elegant approach is to change the relevant axis when one of the cells within B14: C16 changes.
Or you can manually adjust the axis scales; when the charted values change, you must manually readjust the scales. We can use the has appeared automatically atop the module.
The cells B14: C16 can contain static values which the user can manually change, or they can contain formulas with your favorite axis scaling algorithms.
See how to set up axis-scaling formulas in Calculate Nice Axis Scales in Your Excel Worksheet.
Search for self updating excel graphs:
The shading may help to indicate a target range for the data.