WyzGuys Computer Tutors

 Computer Instruction. Web Design Instruction,  and Web Hosting 

 

Charting with Excel

 

Site Navigation

Introduction
Register
Resources
Excel Window
Toolbars
Create A Workbook
Save A Workbook
Open A Workbook
The Active Cell
Entering Data
Editing Data
Formatting Cells
More Formatting
Worksheets
Move & Copy Data
Fill a Range
Formulas
AutoSum
Functions
Copy Formulas
Print Preview
Page Orientation
Margins
Headers & Footers
Titles & Gridlines
Printing
Sorting Data
Charting
Modify Charts

 

Charts

Excel can easily create charts using the data contained in a worksheet.  The Excel Chart Wizard will make a variety of charts, including column charts, bar charts, pie charts and line charts.  Excel charts are linked to their underlying data; if the data changes, the chart changes. 

To create a chart from data in a worksheet:

1. Select the data you wish to chart.  Remember to omit cells containing totals for comparison charts.

 

2. Click the Chart Wizard button   on the standard toolbar.

3. In the Chart Type pane of the chart wizard, select the type of chart you wish to use.  Column (vertical) and bar (horizontal) charts are good choices for comparing data.  Pie charts illustrate parts of a whole.  Line charts can be used to illustrate trends over time.

4. In the Chart Source Data pane, choose to display either your row or column data series.  Remember, charts should make data easier to understand.

5. In the Chart Options pane, type labels for each axis and a chart title.  Use the tabs at the top of the window to locate the legend, change gridlines, and display data labels.

 

6. In the Chart Locations pane, choose to place the chart on a separate worksheet or as a picture on the current worksheet.  Click Finish.
Back To Exercise 24 Next

 

Curriculum developed by WyzGuys Computer Tutors

All Rights Reserved - updated 12/07/2006

Hosted by WyzHost.com

contact support@wyzhost.com