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
   15   16   17   18   19   20   21   22   23   24   25