Monday, January 17, 2011

How to Add Charts to Excel 2007


1. Open a worksheet in Excel. Enter the data into your worksheet using the columns and rows. Label each column and row, and place a title at the top of your table.
2. Select all of data you want displayed in your chart. Be sure to include the row labels, column titles and the title of your chart.
3. Click the 'Insert' tab at the top of your spreadsheet, and click the type of chart you want to add to your worksheet. The chart types are located in the 'Charts' group.
4. Change the type of chart by right-clicking the chart and selecting 'Change Series Chart Type.' Experiment with the many types until you find one that suits your needs.
5. Edit the information in your chart by changing the data entered into your table.
6. Move your chart by left-clicking anywhere in the white area. Drag the chart with your mouse to the desired location.
7. Change the colors or style of the data on your chart by selecting the specific bar, line or sector. Right-click and select 'Format Data Series.' In the Format Data Series dialog box, you can change the shape, fill, border color, border style, shadow and 3-D format.
8. Change the size of your chart by clicking anywhere inside the chart. Grab any outside corner and drag it in or out.

Blogger news