Wednesday, December 28, 2011

How to Make a Bar Graph in Excel 2007


1. Start a new document and add data or open the document containing the data you wish to convert into a graph. Arrange the data with the item headers at the top of the column and data in the same column or the headers at the beginning of the row and the data to the right.
2. Select the data you want to include in the graph.
3. Click on the 'Insert' tab in the ribbon.
4. Click on the down arrow under the 'Bar' graph icon.
5. Choose the graph design you like the best. Your data will convert into a bar graph on the spreadsheet.
6. Click on the 'Design' tab to change colors, layout, add a title, switch the rows and columns, move the chart, change the chart type or save as a template.

Blogger news