All you need to do is follow these steps: Also: How to add a drop down list in Google Sheets No formula is needed to create ...
To create a chart in an Excel report sheet ... and select all cells containing the data you want to chart (include headers). The chart will update in your report sheet with the data.