Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 61 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 61

    5                   advanced features of Calc

                         Goal Glimpse

                             Charts in Calc                                  Creating and Formatting Charts

                             Consolidating Data                              Group and Outline

                     In the previous chapter, you learned how to work with cell references, ranges, formulas and
                     functions in Calc. Building on that, this chapter you will learn how to create and format charts,

                     consolidate data from multiple sheets and group sheets for more efficient data analysis and
                     presentation.

                           CHARTS IN CALC

                     A chart is an effective way to display data in a pictorial form. It makes it easier to draw comparison
                     and analyse the growth, relationship and trends among the values in a table.
                     Components of a Chart

                     A char has the following components:
                         Chart Title: Chart title describes the main aim and content of the chart, which represents
                         your chart.

                         X-axis: X-axis is the horizontal axis of the chart. It is also called the category axis.
                         Y-axis: Y-axis is the vertical axis of the chart. It is also called the value axis.

                         Plot Area: It is the rectangular area bounded by the two axis. It contains the actual chart and
                         includes the plotted data, data series, category and value axis.
                         Data Series: Data series is related to the set of values. It is represented by the bars or slices
                         that represent the data values.
                         Data Labels: Data labels includes data values, category name, series name, legend keys and

                         values from cells.
                         Gridlines: These can be either horizontal or vertical lines depending on the selected chart
                         type. It makes it easier to read and understand the values.

                         Legend: Legend is a key which shows the meanings of symbols and colours used in the chart.
                         Chart Area: The area that includes all objects and elements in a chart.

                                                                                         Advanced Features of Calc       59

| 56 57 58 59 60 61 62 63 64 65 66 |