Sunday, August 14, 2011

How to Make a Graph in Excel Edit the Legend


Create a Chart
1. Open the Excel worksheet that contains the data for the chart.
2. Click and drag to select the data for the chart.
3. Click the “Insert” tab on the command ribbon.
4. Click the arrow for the preferred chart type in the “Charts” group. Examples of chart types include 'Column,' 'Line' and 'Pie.' A gallery of chart thumbnails appears.
5. Click to select the chart type. A chart displays over the Excel worksheet. The “Chart Tools” ribbon shows three tabs: “Design,” “Layout” and “Format.”
6. Format and style your chart with the commands on the “Design,” “Layout” and “Format” tabs. For example, the “Design” tab contains options for “Chart Layouts” and “Chart Styles.”
Edit the Chart's Legend
7. Click the Excel chart. The 'Chart Tools' ribbon appears.
8. Click the “Design” tab in the “Chart Tools” ribbon.
9. Click the “Select Data” button in the “Data” group. The “Select Data Source” dialog window opens.
10. Click the “Add,” “Edit” or “Remove” options in the “Legend Entries (Series)” section. Update the legend. Click “OK.”
11. Right-click the legend box. A dialog box displays options for “Legend Options,” “Fill,” Border Color,” “Border Styles,” “Shadow” and “Glow and Soft Edges.”
12. Click to select the preferred options to format your chart’s legend.
13. Click “Close.”

Blogger news