Excel's OFFSET function lets you create a reference that isquite literally offset from a starting point. It allows references to adjust dynamically to changes in your spreadsheet's data and structure.

Learn how to change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name.

However, if you add a series of data points to a spreadsheet, Excel doesn't know to include these on an existing chart. To include this data, you must manually add the series to the chart.

How to Add a Second Y-Axis on Excel & Make a Second Series at the End of the Chart. Microsoft Excel charts give you a large number of options for displaying the data in your spreadsheet.