How to Use Microsoft Excel to Make a Bar Graph

Make a Bar Graph in Excel 2003
1. Enter the data you want to use into columns or rows in the Excel worksheet with a column or row of labels and a column or row of data.
2. Select the cells containing the data you entered. Click and hold the left mouse button and drag over the cells, or press and hold the 'Ctrl' key and click on each cell you want to select.
3. Click the 'Chart Wizard' button on the standard toolbar. Select 'Bar' under 'Chart Type.' Select a bar graph subtype in the 'Chart Subtype' box. Click 'Next.'
4. Select any other settings desired. Click 'Finish' to complete the wizard and add the bar graph to your Excel worksheet.
Make a Bar Graph in Excel 2007
5. Enter the data you want to use into columns or rows in the Excel worksheet with a column or row of labels and a column or row of data.
6. Select the cells containing the data you entered. Click and hold the left mouse button and drag over the cells or press and hold the 'Ctrl' key and click on each cell you want to select.
7. Go to the 'Insert' tab. Click 'Bar' in the 'Charts' group. Select a bar graph subtype to add the chart to the current worksheet.
8. Click on the chart to select it. Go to the 'Design' tab under 'Chart Tools' to select a different layout or move the chart to another sheet.
9. Go to the 'Format' tab under 'Chart Tools' to make formatting changes, such as shape styles and colors. Save the worksheet before closing it.