Page 20 - TP-Play_V-2.0_Book-7
P. 20
Changing Chart Design
Excel 2016 has some in-built chart styles. These styles are listed in the Chart Styles group of the
Design tab. You can select the chart and click on any of these layouts to change the design of
your chart.
You can also change the colour scheme of the bars of your chart. Select a scheme from Chart
Styles group under the Design tab. A 3-D effect can also be applied to the chart using these
Chart Styles. A 2-D and 3-D chart styles may look like these.
2-D chart style 3-D chart style
Recap
Charts make it easier to draw comparisons, analyse growth and relationship among
the values.
Components of a chart are chart title, X-axis, Y-axis, plot area, data series, data labels,
gridlines, legend and chart area.
Excel 2016 provides a variety of different chart formats such as Bar, Column, Pie, Line,
Area, Waterfall, Scatter, Surface or Radar.
Excel 2016 provides various tools to improve the appearance of a chart.
Exercise
A. Tick ( ) the correct option.
1. Which of these is the vertical axis that is used to plot the values?
a. Bar b. Data c. Value Axis d. Plot Area
2. Which of the following is the rectangular area bounded by the two axis?
a. Plot Area b. Chart Area c. Gridlines d. Value Axis
20 Play (Ver. 2.0)-VII

