How Do You Create A Bar Graph From An Excel Spreadsheet?
For most people, a picture is more compelling than columns of numbers in cells, so convert your spreadsheet to a bar chart or line graph. These steps are intended for Microsoft Excel 97. Creating a Chart Step 1 Start Microsoft Excel, and open the file you want to use to make a chart. Step 2 Drag the cursor over the columns you want to show in your chart. Step 3 Open the Insert menu, and select Chart. You can also select the chart icon on the toolbar. Step 4 Select the type of chart you want to make, such as a line graph or pie chart, from the list on the left. Step 5 Press Finish if you do not want to label or format your chart. Step 6 Press Next to label and format your chart. Formatting Your Graph Step 1 In the box that appears after you clicked Next, click the Series tab. Step 2 Click on Series1, and enter a label for your data, such as “Number of Widgets per Month,” in the Name field. Step 3 Click on any additional series, and name those as well. Step 4 Click Next. Step 5 Select th
For most people, a picture is more compelling than columns of numbers in cells, so convert your spreadsheet to a bar chart or line graph. These steps are intended for Microsoft Excel 97. Start Microsoft Excel, and open the file you want to use to make a chart. Drag the cursor over the columns you want to show in your chart. Open the Insert menu, and select Chart. You can also select the chart icon on the toolbar. Select the type of chart you want to make, such as a line graph or pie chart, from the list on the left. Press Finish if you do not want to label or format your chart. Press Next to label and format your chart. In the box that appears after you clicked Next, click the Series tab. Click on Series1, and enter a label for your data, such as “Number of Widgets per Month,” in the Name field. Click on any additional series, and name those as well. Click Next. Select the Titles tab to label your chart and both its x-axis and y-axis. Select the Axes, Gridlines, or Legend tabs to forma
