Updating excel graph
We will need to create a chart title in another cell that will be referenced by the chart title.
If you can’t remember how to do this please check the earlier tutorial as it covers this.
Excel, we’re going to expand the concepts used to create the dynamic data table and create another sheet for the same workbook that will be the home of an automatically updating chart!
Unlike pivot charts, this will be able to update as soon as new data is inputted into the data backsheets, and will be connected to the same ‘linked cell’ as our previous combo box, so the changes will be persistent throughout the workbook.
Utilising the principles from this tutorial you should be able to create any type of chart you’d like, and tailor pick the data to create the chart.
Again, we will set-up some named ranges for our input range and linked cell for our organisation list.