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
   69   70   71   72   73   74   75   76   77   78   79