LibreOffice-Suite-Calc-6.3/C3/Using-Charts-and-Graphics-in-Calc/English-timed
From Script | Spoken-Tutorial
| TIME | NARRATION |
| 00:01 | Welcome to the Spoken Tutorial on Using Charts and Graphs in Spreadsheets. |
| 00:07 | In this tutorial, we will learn how to: |
| 00:11 | Create, Edit, Resize |
| 00:14 | Format, Move and Delete
charts in LibreOffice Calc |
| 00:21 | This tutorial is recorded using
Ubuntu Linux OS version 18.04 and LibreOffice Suite version 6.3.5 |
| 00:35 | Charts can powerfully convey information to the reader |
| 00:40 | LibreOffice Calc offers a variety of chart formats for our data |
| 00:46 | Using Calc, we can customize charts to a considerable extent |
| 00:52 | Let us open our Personal Finance Tracker dot ods file. |
| 00:58 | This file has been provided to you in the Code files link on this tutorial page |
| 01:04 | Please download and extract the file
Make its copy and use it for practising |
| 01:13 | Notice that all cell borders are incomplete.
Let us sort this out first. |
| 01:20 | Select cells A1 to H8. |
| 01:25 | Then go to the Formatting toolbar and select the dropdown next to the Borders icon. |
| 01:32 | Select the option that will display all borders. |
| 01:37 | Click anywhere outside the selected area to deselect the cells. |
| 01:42 | Our chosen border style is now applied to all the selected cells. |
| 01:48 | We do not need the Days and Date columns anymore. |
| 01:53 | So, let us delete them as shown. |
| 02:00 | Let us fill the amount spent for each item listed in the Spent column. |
| 02:06 | Next, we’ll fill the amounts received for each item listed in the Received column. |
| 02:13 | Let us now format the values in Spent and Received columns to INR currency format. |
| 02:21 | Select the cells D3 to E7, by holding the Shift key and clicking like this. |
| 02:29 | On the Formatting toolbar, select the dropdown of the Format as Currency icon. |
| 02:36 | Scroll down and select the option INR ₹ English India. |
| 02:43 | Click anywhere outside the selected area to deselect the cells. |
| 02:48 | Now our spreadsheet has the necessary data we need to proceed ahead. |
| 02:54 | So, let us see how to create a chart for this data. |
| 02:59 | To create a chart, first we have to select the data to be included in the chart. |
| 03:05 | Select cells A1 to E7. |
| 03:09 | The selection can be verified in the Name Box at the top left. |
| 03:15 | Now, click on the Insert Chart icon in the Standard toolbar. |
| 03:21 | Alternatively, we can click on the Insert menu in the menu bar.
And then click on the Chart option. |
| 03:30 | Either ways, the Chart Wizard dialog box opens.
It shows several options to select. |
| 03:39 | For now, keep the default settings and click on the Finish button at the bottom. |
| 03:46 | A chart gets inserted in the spreadsheet based on our data. |
| 03:52 | But, the chart is covering up some of the data.
So we have to resize the Chart. |
| 04:00 | When the chart is selected, we see handles around it. |
| 04:06 | Click and drag any of the corner handles to resize the chart proportionally. |
| 04:13 | Now let’s move the chart. |
| 04:16 | Place the cursor on any one of the borders till the cursor turns into a hand. |
| 04:22 | Click and move the chart to the desired location and then release the mouse button. |
| 04:29 | Click anywhere else outside the Chart to deselect it. |
| 04:34 | Now, we can see our data and the Chart clearly. |
| 04:39 | To customise the Chart, double-click on it. |
| 04:43 | Immediately, the Formatting toolbar shows only the options related to the Chart. |
| 04:50 | If you wish to exit the Chart edit mode, click anywhere outside the Chart. |
| 04:56 | First, we will learn to add a Title to this chart. |
| 05:01 | Click on the Titles icon on the Formatting toolbar. |
| 05:06 | The Titles dialog box opens. |
| 05:10 | In the Title text field, type Finance Tracker. |
| 05:15 | Leave the rest of the fields as default. |
| 05:18 | Then click on the OK button at the bottom. |
| 05:23 | Observe that the title Finance Tracker, is displayed at the top center of the chart. |
| 05:29 | Next, let us learn how to change the Chart Type. |
| 05:34 | Click on the Chart Type icon on the Formatting toolbar. |
| 05:39 | The Chart Type dialog box opens. |
| 05:43 | On the left we can see a list of available Chart Types. |
| 05:48 | Column type is selected by default. |
| 05:52 | On the right side, we can see three sub-types of Column charts. |
| 05:57 | This will vary based on the selected Chart type. |
| 06:01 | We will retain the Normal sub-type Column chart. |
| 06:05 | If we check the 3D Look option, the chart will get displayed in three dimensions. |
| 06:11 | Immediately we see that the Shape option gets enabled. |
| 06:17 | Select the shape as Cylinder and also select the sub-type as Deep. |
| 06:23 | Then click on the OK button at the bottom. |
| 06:27 | Observe the change in the chart on the spreadsheet. |
| 06:31 | Explore the other combinations on your own later. |
| 06:35 | Next, let us learn how to change the Data Range. |
| 06:40 | Click on the Data Ranges icon on the Formatting toolbar. |
| 06:45 | The Data Ranges dialog box opens. |
| 06:49 | Using this option, we can manually edit the range of data we want to represent in the chart. |
| 06:56 | The default option for plotting data is Data series in columns. |
| 07:02 | But we can change how we want to plot the data. |
| 07:06 | Let’s change this and use Data series in rows. |
| 07:11 | This is useful if we use a style of chart such as Column to display our data. |
| 07:18 | Next, we can choose whether to use
First row as label, or First column as label, or both as labels on the axes of the chart. |
| 07:32 | This is my selection. |
| 07:35 | Now, suppose we wish to remove the data under the column Received. |
| 07:41 | To do that, first click inside the Data range field. |
| 07:46 | Then change the range from dollar A dollar 1 is to dollar E dollar 7 to dollar A dollar 1 is to dollar D dollar 7. |
| 08:00 | The data under the column Received will no longer be represented when the chart is ready. |
| 08:07 | Next, we’ll see the functions of the Data Series. |
| 08:12 | So, click on the Data Series tab. |
| 08:16 | Notice there are 6 fields representing the column headings of our data. |
| 08:22 | The Add and Remove buttons will allow us to add or remove rows of data from the chart. |
| 08:30 | We can also sort the data by using the Down and Up buttons. |
| 08:36 | Now we have finished selecting the data and how to represent the data in the chart. |
| 08:43 | So we will click on the OK button at the bottom. |
| 08:48 | Observe all the changes we made in the chart. |
| 08:52 | Next, let us learn how to further customise the Chart area. |
| 08:58 | Click on the Chart Area icon from the Formatting toolbar. |
| 09:03 | There are 3 tabs at the top - Borders, Area and Transparency.
By default, the Borders tab is selected. |
| 09:15 | There’s a large white box here which is the preview area. |
| 09:20 | Let us change the style and color of the chart's border. |
| 09:26 | To do so, click on the Style drop-down and choose Continuous. |
| 09:31 | Then in the Color drop-down, we’ll choose Green. |
| 09:36 | Notice the changes in the preview area. |
| 09:40 | Now click on the OK button at the bottom. |
| 09:44 | Click outside the chart to see all the changes. |
| 09:48 | Notice that the style and color of the chart border has changed. |
| 09:54 | Let us check out a few more formatting options. |
| 09:58 | Make sure the chart is in Edit mode only. |
| 10:03 | On the Formatting toolbar, there are 4 axis icons. |
| 10:08 | These axis options help to format the lines that create the chart. |
| 10:14 | These also format the font of the text that appears on both the X and Y axes.
Let’s check these out. |
| 10:24 | Click on the X Axis icon in the Formatting toolbar.
The X Axis dialog box opens. |
| 10:33 | Here we can see various tabs at the top to customise the X Axis. |
| 10:39 | Press the Esc key or click on the Cancel button at the bottom to exit the dialog box. |
| 10:47 | Likewise, we can also format the Y Axis by clicking on the Y Axis icon in the Formatting toolbar. |
| 10:55 | Explore the other axis icons on your own later. |
| 11:00 | Calc provides an option for changing the colour of the chart wall. |
| 11:05 | The chart wall is the border surrounding the chart graphic, including the main title and key. |
| 11:12 | To format, click on the Chart Wall icon in the Formatting toolbar.
The Chart Wall dialog box opens up. |
| 11:22 | Go to the Borders tab if not already selected. |
| 11:26 | Under the Line Properties option, we can see that the Style is set to Continuous. |
| 11:33 | From the Color drop-down, let’s choose Red. |
| 11:38 | Then change the width to 0.10 centimeter by clicking the plus icon. |
| 11:45 | Now click on the OK button at the bottom. |
| 11:49 | We can see the style and colour of the chart wall has now changed. |
| 11:54 | Next, we will learn how to remove and add the Legend.
In our chart, this is the Legend. |
| 12:02 | Click on the Legend ON/OFF icon in the Formatting toolbar.
The legend disappears. |
| 12:10 | Click again on the Legend ON/OFF icon and the legend reappears. |
| 12:16 | Next we will learn how to resize charts by using the Position and Size dialog box.
Click anywhere outside the Chart to exit the edit mode. |
| 12:28 | Now right-click on the chart.
From the context menu, select Position and Size. |
| 12:36 | The Position and Size dialog box appears. |
| 12:41 | Select the Position and Size tab at the top. |
| 12:45 | The Position section has various fields that can set the X and Y positions of the chart. |
| 12:53 | We can also adjust the width and height of the chart under the Size section. |
| 12:59 | Let’s set the X coordinate to 1.00 and Y coordinate to 0.80. |
| 13:09 | And click on the OK button at the bottom. |
| 13:13 | Notice that the position of the chart has changed according to the assigned values. |
| 13:19 | Apart from these options available in the Formatting toolbar, we can format the chart in two other ways. |
| 13:27 | Either go to the Format menu in the menu bar. Or right click on the chart. |
| 13:34 | To see the formatting options, make sure that the chart is in edit mode.
Explore these options on your own later. |
| 13:43 | Lastly let’s learn how to delete a chart. |
| 13:47 | Click on the chart and press the Delete key on the keyboard. |
| 13:52 | Notice that the chart is now deleted from the spreadsheet. |
| 13:57 | Now let’s save and close the file. |
| 14:01 | This brings us to the end of this tutorial. Let us summarize. |
| 14:06 | In this tutorial, we learnt to:
Create charts, resize and move them within the spreadsheet |
| 04:14 | Edit and format the charts and Delete a chart |
| 14:20 | As an assignment
|
| 14:26 | Insert a Pie chart for the data . Resize and move the chart to the bottom right corner of the sheet |
| 14:35 | The video at the following link summarizes the spoken tutorial project.
Please download and watch it. |
| 14:43 | The Spoken Tutorial Project Team conducts workshops and gives certificates.
For more details, please write to us. |
| 14:53 | Please post your timed queries in this forum. |
| 14:57 | Spoken Tutorial project is funded by MHRD, Govt. of India. |
| 15:03 | This tutorial was originally contributed by DesiCrew Solutions Pvt. Ltd. in 2011 |
| 15:11 | This is Arvind along with Spoken Tutorial team from IIT Bombay signing off.
Thank you for watching. |
