MS Excel - Charts

Charts are used to
display series of
numeric data in a
graphical format to
make it easier to
understand large
quantities of data and
the relationship
between different
series of data.
yasirbhutta@uaf.edu.pk

 The entire chart and all
its elements.

 In a 2-D chart, the area
bounded by the axes,
including all data
series. In a 3-D chart,
the area bounded by
the axes, including the
data series, category
names, tick-mark
labels, and axis titles.

 The data points of the data
series that are plotted in the
chart.
 Individual values plotted in a
chart are called data markers.
Data markers of the same
color constitute a data series.
 Related data points that are
plotted in a chart. Each data
series in a chart has a unique
color or pattern and is
represented in the chart
legend. You can plot one or
more data series in a chart.
Pie charts have only one data
series

 The horizontal (category)
and vertical (value)
axis along which the
data is plotted in the
chart.
 The y axis is usually the
vertical axis and
contains data.
 The x-axis is usually the
horizontal axis and
contains categories.

 A box that identifies
the patterns or colors
that are assigned to
the data series or
categories in a charts.

 A label that provides
additional information
about a data marker,
which represents a
single data point or
value that originates
from a datasheet cell.

 Descriptive text that is
automatically aligned
to an axis or centered
at the top of a chart.

1. Column
2. Line
3. Pie
4. Bar
5. Area
6. Scatter
7. Stock
8. Surface
9. Doughnut
10. Bubble
11. Radar

1. On the worksheet, arrange the data that you
want to plot in a chart.
2. Select the cells that contain the data that
you want to use for the chart.
3. On the tab, in the group Click
the , and then click a
that you want to use.
4. By default, the chart is placed on the
worksheet as an embedded chart.

 A pie chart shows only a
single data series.
 Pie charts are very
useful charts to show
percentage distribution.

A 1
B 2
C 3
A B C
1 2 3

 One or more ranges of
cells that you
designate to print
when you don't want to
print the entire
worksheet.
 If a worksheet includes
a print area, only the
print area is printed.

 On the worksheet, select
the cells that you want to
define as the print area.
 On the Page Layout tab,
in the Page Setup
group, click Print Area,
and then click Set Print
Area.
Note: The print area that
you set is saved when
you save the workbook.

 On the worksheet,
select the cells that
you want to add to the
existing print area.
 On the Page Layout
tab, in the Page Setup
group, click Print
Area, and then click
Add to Print Area.

 Click anywhere on the
worksheet for which
you want to clear the
print area.
 On the Page Layout
tab, in the Page Setup
group, click Clear
Print Area.

 If a worksheet spans more than one page,
you can print row and column headings or
labels (also called print titles) on every page
to ensure that the data is properly labeled.

 Select the worksheet that you want to print.
 On the Page Layout tab, in the Page Setup
group, click Print Titles.
 On the Sheet tab, under Print titles, do one or
both of the following:
› In the Rows to repeat at top box, type the reference
of the rows that contain the column labels.
› In the Columns to repeat at left box, type the
reference of the columns that contain the row labels.

 Before printing a worksheet you can see how the sheet
will look when you print it
 Print Preview allows you to adjust the columns and
margins easily
 Preview window has buttons to
› get different views of the pages
› go to the Print and Page Set up dialog boxes
› view all the pages of the worksheet in preview

 Click the worksheet or select the worksheets that
you want to preview.
 Click the Microsoft Office Button , click the arrow
next to Print, and then click Print Preview.
Keyboard shortcut You can also press
CTRL+F2.
 To preview the next and previous pages, on the
Print Preview tab, in the Preview group, click Next
Page and Previous Page.
 To view page margins, on the Print Preview tab, in
the Preview group, select the Show Margins
check box.

 On the status bar, click the Page Layout
button to switch from Normal to Page Layout
view.
 In the Scale to Fit group, in the Width box,
select 1 page, and in the Height box, select
1 page. Columns will now appear on one
page, but the rows may extend to more than
one page.

MS Excel - Charts

More Related Content

What's hot

Similar to MS Excel - Charts

More from Muhammad Yasir Bhutta

Recently uploaded

MS Excel - Charts