Page 23 - TP_Play_V2.1_class7
P. 23

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.











                                                                                              Charts in Excel     21
   18   19   20   21   22   23   24   25   26   27   28