Page 28 - Code & Click - 7

Try This Critical Thinking
Identify and write the name of the chart element in Excel:
(a) Used to describe the contents of a chart. _______________
(b) Used to identify which data series is represented by which colour. _______________
(c) Used to describe values represented on X and Y axes. _______________

(d) Used to display values of various data points in a chart. _______________

2
CHANGING CHART TYPE
You can change the type or sub-type of the inserted
chart.
To change the chart type:

1. Select the chart whose type you want to change.
2. On the Chart Design tab, click the Change Chart
Type button in the Type group.

The Change Chart Type dialog box opens with the
All Charts tab selected.

1

3

3. Select the desired chart type and click the OK button.
Excel changes the chart type of the selected chart.

CHANGING CHART LAYOUT
The overall arrangement of a chart’s
elements is called its Layout. You can
apply various predefined chart layouts
that include a combination of different
chart elements.

To change layout of a chart:

1. Select the chart whose layout
you want to change.
1

26