Page 69 - TechPluse_C6_Flipbook
P. 69

Creating a Chart

                 To create a chart, follow these steps:

                 Step 1    Select the range of cells that contains data, for example A1:C6, in this case.

                 Step 2    Select  the  Insert  → Chart  option  from  the  menu  bar.  The  Chart  Type  dialog  box
                           appears.












                                    Selecting a range                                 Inserting a Chart

                 Step 3    Select a chart type. In this case, we have selected Column.

                 Step 4    Click on the Next>button. The selected range is already shown in Data Range text box
                           of Data Range dialog box.















                                 Chart Type dialog box                           Data Range dialog box


                 Step 5    Click on the Next>button. The Data Series dialog box appears. This dialog box is used
                           to define properties of data series shown in chart.

                 Step 6    Click on the Next>button. The Chart Elements dialog box appears.

                 Step 7    Type titles for chart, x-axis and y-axis in respective text boxes.

                 Step 8    Click on the Bottom radio button of Display Legend section.
                 Step 9    Click on the Finish button. A chart will be inserted in the worksheet as shown.
















                                                         Data Series dialog box

                                                                        Formulas, Functions and Charts in Calc       67
   64   65   66   67   68   69   70   71   72   73   74