|
Charts can make
data interesting, attractive, and easy to read and
evaluate. They can also help you analyze and compare
data.
A chart can be created directly onto a worksheet as
an embedded chart or as a separate chart sheet within
your workbook. When you want to view or print the
chart and the worksheet data together, you should
use an embedded chart. If you want to use the chart
by itself (for example, in a presentation) you should
use a chart sheet. Whether you want to use an embedded
chart or a separate chart the procedures for creating
them are the same. In the final stages of creating
a chart you can decide which best suits your needs.
Both embedded charts and chart sheets are linked to
the source worksheet, so the chart is always updated
when you update the source data.
Creating Chart
· Create a worksheet medical expenses with the following
data. Select the cell range A1:B13.
Column Charts
· Select the range of cells containing the data (A1:B13).
· From the Insert menu choose Chart, or click the
Chart
Wizard button
· Select a Column chart type from the Chart type list
box as below.
· Select a chart sub-type under Chart sub-type as
below.
· You can preview
the selected chart type and sub-type by clicking and
holding the Press and hold to view sample button.
· Under the Custom Types tab are a variety of pre-formatted
chart types including combination charts and some
with automatic colouring, backgrounds and effects.
· Click Next.
· Select the desired data orientation from the Series
in options, if necessary.
· Click Next.
· From the available tabs add further features to
your chart such as titles, gridlines, legend and
data labels:
· Click Next.
· Select the desired chart placement under Place
chart.
·
If you choose As new sheet, Excel places the chart
on a new chart sheet (named Chart1), which
is then inserted into your workbook to the left of
the worksheet that the chart is based on.
· If you choose As object in, you can specify into
which worksheet the chart is embedded. By default
it is embedded in the sheet containing the data which
the chart is based on.
· Click Finish.
¨ Editing a chart
If you want to change a chart feature after you
have created a chart, you can edit the chart using
the same dialogue boxes as used in the Chart Wizard
or use features contained on the Chart toolbar.
Editing using the Chart Wizard
· Select the chart you wish to edit by clicking
a blank area inside the chart.
· When selecting a chart if you click a single object
within the chart, for example the legend or the
title, only the object you clicked is selected,
not the entire chart.
· From the Chart menu choose either: Chart Type…
· Source Data…
· Chart Options…
· Location…
Editing using the Chart toolbar
Whenever a chart or chart object is selected, the
Chart toolbar should always appear. If it does not,
from the View menu choose Toolbars, Chart.
Table 4.2
|