Monday, May 16, 2011

How to Create a Bar Graph From an Excel Spreadsheet


Creating a Chart
1. Start Microsoft Excel, and open the file you want to use to make a chart.
2. Drag the cursor over the columns you want to show in your chart.
3. Open the Insert menu, and select Chart. You can also select the chart icon on the toolbar.
4. Select the type of chart you want to make, such as a line graph or pie chart, from the list on the left.
5. Press Finish if you do not want to label or format your chart.
6. Press Next to label and format your chart.
Formatting Your Graph
7. In the box that appears after you clicked Next, click the Series tab.
8. Click on Series1, and enter a label for your data, such as 'Number of Widgets per Month,' in the Name field.
9. Click on any additional series, and name those as well.
10. Click Next.
11. Select the Titles tab to label your chart and both its x-axis and y-axis.
12. Select the Axes, Gridlines, or Legend tabs to format the look of your chart.
13. Select the Data Label tab to label specific points on your chart.
14. Select the Data Table tab to add a table of chart data under your chart.
15. Click Next.
16. Decide whether you want your chart on a new worksheet or on the same worksheet with your current Excel entries.
17. Click Finish.

Blogger news