Page 79 - modular4.0
P. 79

Chapter Profile
                 Changing Chart Design

                 Excel 2019 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 2019 provides a variety of different chart formats such as Bar, Column, Pie, Line, Area, Waterfall,
                       Scatter, Surface or Radar.
                       Excel 2019 provides various tools to improve the appearance of a chart.






                 Exercise



                 A.   Tick ( ) the correct option.
                     1.  Which tab has the Chart option?

                         a.  Charts                                     b.  Home
                         c.   Insert                                    d.  Layout

                     2.  Which area includes all objects and elements in a chart?
                         a.  Plot Area                                  b.  Chart Area

                         c.  Data Area                                  d.   Legend




                                                                                                      Charts in Excel  77
   74   75   76   77   78   79   80   81   82   83   84