MS Excel TUTORIAL/REVIEW

Back | Back To Start | Next

6 Charts- The Chart Wizard

To use the Chart Wizard :

Enter the data into the worksheet and highlight all the cells that will be included in the chart including headings.

NOTE: The first cell you highlight will remain white. It is highlighted, so don't worry.

Click theChart Wizard button.

Choose the Chart type and the Chart subtype.

Click Next.

Chart Options

Enter the name of the chart and titles for the X- and Y-axes.

Press Next to move to the next set of options.

Chart Location

Click

As new sheet if the chart should be placed on a new, blank worksheet.

or

As object in if the chart should be put in a separate worksheet.

Click Finish to create the chart.

Resizing the Chart

To resize the chart, click on its border and drag any of the nine black handles to change the size.

Chart Formatting Toolbar

First, click on the chart.

Chart Type - Click the arrowhead on the chart type button to select a different type of chart.

Legend Toggle - Show or hide the chart legend by clicking this toggle button.

Angle Text

Select the category or value axis and click the Angle Downward
or
Angle Upward button to angle the the selected by +/- 45 degrees.

This is useful for making all the labels on the axis show.

Copying the Chart to Microsoft Word
A finished chart can be copied into a Microsoft Word document. Select the chart and click Copy. Open the document in Word and click Paste.

Spreadsheet 123 Spreadsheet Software Development