Creating a Chart

graphics/microsoft47.gif

A chart provides a visual, graphical representation of numerical data. Whether you turn numbers into a bar, line, pie, surface, or bubble chart, patterns become more apparent. For example, the trend of annual rising profits becomes powerful in a line chart. A second line showing diminishing annual expenses creates an instant map of the success of your business. Titles on the chart, horizontal (x-axis), and vertical (y-axis) identify the data. A legend connects the colors and patterns in a chart with the data they represent. Gridlines are horizontal and vertical lines to help the reader determine data values in a chart. Excel simplifies the chart-making process with the Chart Wizard , a series of dialog boxes that leads you through all the steps to create an effective chart on a new or an existing worksheet. When you choose to place the chart on an existing sheet, rather than on a new sheet, the chart is called an embedded object. You can then resize or move it just as you would any graphic object.

Create a Chart Using the Chart Wizard

graphics/one_icon.jpg Select the data range you want to chart.

Make sure you include the data you want to chart and the column and row labels in the range. The Chart Wizard expects to find this information and incorporates it in your chart.

graphics/two_icon.jpg Click the Chart Wizard button on the Standard toolbar.

To move backward or forward in the Chart Wizard, click Back or Forward. You can click Finish at any time.

graphics/three_icon.jpg

Click a chart type.

graphics/four_icon.jpg

Click a chart sub-type.

graphics/five_icon.jpg

Click the Press And Hold To View Sample button to preview your selection.

graphics/six_icon.jpg

Click Next to continue.

graphics/seven_icon.jpg

Verify the data range, and then select to plot the data series in rows or in columns .

graphics/eight_icon.jpg

Click Next to continue.

graphics/nine_icon.jpg

Click a chart options tab.

  • Titles tab . Type titles for the chart, x-axis, and y-axis in the appropriate text boxes.

  • Axes tab . Select the axes you want to display for the data.

  • Gridlines tab . Select the type of gridlines you want for the x-axis and y-axis.

  • Legend tab . Select options to display a legend and its location.

  • Data Labels tab . Select the labels you want for the data.

  • Data Table tab . Click to add a table to the chart.

graphics/ten_icon.jpg

Preview the options, and then click Next to continue.

graphics/eleven_icon.jpg

Select to place the chart on a new sheet or as an embedded object.

graphics/twelve_icon.jpg

Click Finish.

graphics/thirteen_icon.jpg

Drag the chart to a new location if necessary.

graphics/08inf19.jpg

graphics/08inf20.jpg

graphics/08inf21.jpg

graphics/08inf22.jpg

graphics/08inf23.jpg

Did You Know?

The difference between major and minor gridlines . Major gridlines occur at each value on an axis; minor gridlines occur between values on an axis. Use gridlines sparingly and only when they improve the chart's readability.

You can change chart options . You can revise titles, gridlines, and legends at any time. Select the chart, click the Chart menu, click Chart Options, click the appropriate tab, select or change options, and then click OK.



Show Me. Microsoft Office 2003
Show Me Microsoft Office 2003
ISBN: 0789730073
EAN: 2147483647
Year: 2002
Pages: 418

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net