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.

example, let’s say you have two charts on two different worksheets, and you want to put them both on a single chart sheet for comparison and printing. Follow these steps: ...

Open the Excel spreadsheet to find the chart. Select the chart. Right-click on it and choose the Select Data option.; Select the data series from the Legend Entries box.; Click the Edit button ...