How to Do an Excel Chart With Multiple Legends

1. Open your Microsoft Excel spreadsheet that already has your data entered into the cells.
2. Click on cell A1, followed by 'Control' and 'A.' This is a shortcut that highlights your complete set of data.
3. Click 'Insert' on your toolbar, followed by 'Bar,' 'Pie' or another form of chart that you like. The chart will appear in your spreadsheet.
4. Click on the chart. Click 'Layout' and then the Legend icon. Click the button that specifies the your legend's orientation such as 'Show Legend at Right.' The legend will appear in your chart.
5. Click on the legend table. Click 'Control' and 'C,' followed by 'Control' and 'V.' A second legend will appear in your graph.