Creating a Chart

[ LiB ]

Creating a chart is a simple process using the Excel Chart Wizard. You first decide what data you want to chart and how you want it to look.


graphic/11fig01.gif



graphic/11fig02.gif


NOTE

Traditionally, bar charts compare item to item, pie charts compare parts of a whole item, and line charts show a trend over a period of time.


graphic/11fig03.gif


Next , Excel will try to determine the direction of the data whether the values to be plotted are in rows or columns .


graphic/11fig04.gif



graphic/11fig05.gif


You must now choose whether you want the chart to display on its own sheet or to appear on the same sheet as the data.


graphic/11fig06.gif



graphic/11fig07.gif


The data from the selected cells of the worksheet is plotted in a chart. If the data in the worksheet changes, the chart will also change automatically.

In the next section, you'll learn how to change the size and look of your chart.

NOTE

A quick way to create an Excel chart is to highlight the chart data and press the F11 key.

[ LiB ]


Microsoft Office Excel 2003 Fast & Easy
Windows XP Registry: A Complete Guide to Customizing and Optimizing Windows XP (Information Technologies Master Series)
ISBN: N/A
EAN: 2147483647
Year: 2002
Pages: 157
Authors: Olga Kokoreva

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