Charts
April 3, 2007
Charts, more commonly known as graphs, provide a visual representation of the worksheet
data (EX 147).
Chart Wizard :
oExcel’s Chart Wizard is an easy way to create charts. Through a series of steps,
you provide the information to setup the chart (EX 147).
oThe Chart Wizard consists of four steps:
1) Chart Type – select the type of chart.
2) Chart Source Data – choose the data that is going into the chart.
3) Chart Options – change how the chart looks.
4) Chart Location – specify whether the chart will appear in the same
worksheet or a different one.
Chart Type :
oExcel has 14 different types of charts, we’ll focus on the following four chart
types (EX 149):
Column – values are indicated by the height of the columns.
Bar – values are indicated by the length of the bars.
Line – values are indicated by the height of the line.
Pie – values are indicated by the size of the pie slices.
oTo select the type of chart,
Select the cells that you want to be part of the chart.
Click the Chart Wizard button on the Standard toolbar.
Select the chart type and chart subtype.
Click Next to move to the next step.
Data Source :
