Self updating excel graphs

Still another approach is to create a "dynamic range." This approach works well if the data range you are charting is the only data on the worksheet.

Follow these steps: Now the chart updates automatically regardless of where you add information in your data table.

It's important to remember that you enter new data in a contiguous manner.

You can easily create a chart based on a range of data in a worksheet.

Using our earlier sheet, you'll need five dynamic ranges: one for each series and one for the labels.

Instructions for creating the dynamic range for the labels in column A follow.

The key is to define the chart's source data as a dynamic range.

By doing so, the chart will automatically reflect changes and additions to the source data. First, we'll use the table feature, available in Excel 20-you'll be amazed at how simple it is. To do so, simply select the data range and do the following: Now, update the chart by adding values for March and watch the chart update automatically.

Leave a Reply