Page 226 - DCAP101_BASIC_COMPUTER_SKILLS

Unit 11: Operations of MS Excel

Notes
Table 11.2 Standard Toolbar Chart Options

Button Name Description

Chart Objects Lets you select a chart object such as a plot area, a
chart area, a legend, an axis, or a series.

Format Opens a Format dialog box tailored to the
selected chart object.

Import File Opens the Import File dialog box from which you
can import chart data from another file, such as
an Excel worksheet, into your chart.

View Displays the chart’s datasheet.
Datasheet

By Row Displays datasheet row data as the data series
(the default).

By Column Displays datasheet column data as the data series.

Data Table Displays a table with all the datasheet data in
your chart.

Chart Type Lets you apply a new chart type from a palette
that appears.

Category Axis Displays category axis gridlines.
Gridlines

Value Axis Displays value axis gridlines.
Gridlines

Legend Displays a legend on your chart.

Drawing Displays the Drawing toolbar.

Fill Color Lets you apply fill color and fill effects to selected
objects.

LOVELY PROFESSIONAL UNIVERSITY 219