How to Make a Chart on Excel With More Than One Variable. One of the more useful features in Microsoft Excel is Insert Charts. You can create a wide variety of charts: bar, line, pie and others.

And when you already have a column or row of an Excel spreadsheet loaded with the data in question, you can make a pie chart in about five seconds. Here's how. Check out the products mentioned in ...

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.