Creating a chart in Google Sheets starts with the data. While you can add data to a graph after you create one, it’s best to start with at least one data set.

1. Select the cells you want to add a dropdown menu to. 2. Click Data. 3. Choose Data Validation. 4. When the Data Validation pop up appears, select Allow. 5. Choose List from the menu.

For example, if you want to create a chart using the data in columns B and C on Sheet 1, as well as column A from Sheet 2, you need to add one extra column to Sheet 1. Click on column B on Sheet 1 ...