As well as extensive Excel knowledge, Jonathan has worked in the IT world for over thirteen years as a programmer, database designer and analyst for some of the world's largest companies.
In this case that means 3 ranges for the axis, spend, and revenue values.
The final step to automating this process is to define the series and axis in our graph with the named ranges that we just completed. The problem that you can run into is that Excel will redefine the axis values if one of your series has a different shape.
We defined our named range using a formula, but you can use a static definition as well.
We also took advantage of our named range as a definition for a series on a chart, but you can also use named ranges as parameters in formulas.
All of the tables, charts and graphs will all keep themselves updated automatically.