Page 77 - modular4.0
P. 77

Chapter Profile
                 Area Chart
                 It is used to display the quantitative magnitude of the data graphically. These charts are based on

                 the features of the line chart. They basically emphasise the area between the line and the axis with

                 the help of the colours, textures, pictures, etc.















                 Scatter Chart

                 Scatter charts also known as XY scatter plot charts. They show the correlations between the two sets
                 of values. The x and y axis is used to represent the data plots on the chart.




















                                   Envision your favourite tech personality as a Gizmo Gadget. How would you paint
                                   their portrait in Excel?





                        FORMATTING A CHART


                 Excel 2019 provides various tools to improve the appearance of a chart. When you select a chart on
                 a slide, a new contextual tab named Chart Tools will appear. The Chart Tools tab contains two tabs
                 named Design and Format.









                                                            Chart Tools tab
                 These tabs contain various commands to change the layout, style, type and shape of the chart. Let’s
                 learn about some of these in detail.




                                                                                                      Charts in Excel  75
   72   73   74   75   76   77   78   79   80   81   82