Page 74 - TP_Modular_V2.1_Class7
P. 74
Changing Chart Design
Excel 2016 has some in-built chart styles. These styles are listed in the Chart Styles group
under Design tab of the Chart Tools 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 of the Chart Tools tab. A 3-D effect to the chart is done
using the Format tab of the Chart Tools tab. A chart can be created in either 2-D or 3-D formats,
but the styles you select should be appropriate for the chart type. 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.
Line chart is used to show trends over a period of time.
Column chart is usually used to display the data in the form of vertical bars.
Pie is a circular chart divided into sectors where each sector shows the relative size of
each value.
Bar chart displays the data in the form of long rectangular rods.
Area chart is used to display the quantitative magnitude of the data graphically.
Scatter chart shows the correlations between the two sets of values.
Excel 2016 provides various tools to improve the appearance of a chart.
72 Modular (Ver. 2.1)-VII

