LibreOffice-Suite-Calc/C3/Using-Charts-and-Graphs/English-timed
From Script | Spoken-Tutorial
| Time | Narration |
| 00:00 | Welcome to the Spoken tutorial on LibreOffice Calc-Inserting Charts in spreadsheets. |
| 00:07 | In this tutorial, we will learn the following: |
| 00:11 | Creating, editing and formatting charts |
| 00:14 | Resizing and moving of charts. |
| 00:18 | Here, we are using:
Ubuntu Linux version 10.04 and LibreOffice Suite version 3.3.4. |
| 00:27 | So, let us start learning about the various viewing options in LibreOffice Calc. |
| 00:32 | Charts can be powerful ways to convey information to the reader. |
| 00:37 | LibreOffice Calc offers a variety of chart formats for your data. |
| 00:43 | Using Calc, you can customize charts to a considerable extent too. |
| 00:48 | Let us open our "personal finance tracker.ods" sheet. |
| 00:53 | And let us fill the amount spent on each of the items listed in the sheet. |
| 00:59 | We will click on the cell referenced as “E3” and type the amount as “6500”. |
| 01:06 | Now, going down the column, we will type the amounts as-
“1000”, ”625”, ”310” and “2700” in the cell referenced as “E4”, ”E5”, ”E6” and “E7” respectively. |
| 01:26 | Next, we shall fill the amounts received on each of the items listed in the sheet. |
| 01:31 | So, click on the cell referenced as “F3” and type the amount as “500”. |
| 01:37 | Now, going down this column, we will type the amounts as “200”, ”75”, ”10” and “700” in the cells referenced as “F4”, ”F5”, ”F6” and “F7” respectively. |
| 01:54 | Let us now learn how to create a chart for this table. |
| 01:58 | In order to create a chart, we have to first select the data to be included in the chart. |
| 02:04 | So, click on the cell “SN” and without releasing the mouse button, drag the cursor till the last cell which has “700” in it. |
| 02:14 | Now, click on the Insert option in the menu bar and then click on the Chart option. |
| 02:21 | You see that the default chart with the data is inserted into the worksheet. |
| 02:27 | Simultaneously, the "Chart Wizard" dialog-box opens up. |
| 02:32 | The "Chart Wizard" shows that the default chart is selected. |
| 02:36 | This default chart updates to reflect the changes you make in the Chart Wizard. |
| 02:42 | The "Chart Wizard" dialog-box has three main parts- the steps involved in setting up the chart, choice of chart types and the options for each chart type. |
| 02:55 | By checking the “3D Look” option, one can also get the chart displayed in three dimensions. |
| 03:03 | Let's try these options. |
| 03:05 | We will click on the “Bar” option under the “Choose a chart type” field. |
| 03:11 | Observe that the sample chart shows the representation of the data in the table, in the “Bar” format. |
| 03:19 | Similarly, you can click on the other options like “Pie”, <pause> “Area”, <pause> “Bubble” <pause> |
| 03:28 | and many other options under the “Choose a chart type” field and get the required type of chart. |
| 03:35 | Under the Steps option, we have another option named Data Range. |
| 03:40 | Using this option, you can manually edit the range of data you want to represent in the chart. |
| 03:48 | The default option of plotting data is “Data series in columns”. |
| 03:54 | We can change the way we want to plot the data by using “Data series in rows” instead. |
| 04:02 | This is useful if you use a style of chart such as “Column” to display your data. |
| 04:10 | Lastly, you can choose whether to use the “First row as label” |
| 04:24 | or “First column as label”, |
| 04:28 | or both as labels on the axes of the chart. |
| 04:34 | Then click on Data series in column again. |
| 04:38 | Now, in our sample chart, if we wish to remove the data under the heading “Received”, we can do so by first clicking inside the “Data range” field. |
| 04:49 | And then editing the range “$A$1 is to $F$7” to “$A$1 is to $D$7” . |
| 05:03 | Observe that the data under the heading “Received”, is no longer represented in the chart. |
| 05:11 | Next, let's see what “Data Series” does. |
| 05:15 | Notice, there are 5 rows here- representing the total rows of data in our spreadsheet. |
| 05:21 | The Add and Remove buttons will allow us to add or remove rows of data from the chart. |
| 05:29 | We can also re-order the data by using the Up and Down buttons. |
| 05:34 | So, after selecting what and how to represent data in the chart, click on the Finish button in the dialog-box. |
| 05:43 | You see that the chart is inserted into the spreadsheet. |
| 05:47 | After learning about how to insert charts in spreadsheet, |
| 05:51 | we will now learn how to format charts in LibreOffice Calc. |
| 05:56 | The Format menu has many options for formatting |
| 06:00 | and fine-tuning the appearance of the charts. |
| 06:04 | Let us format the chart we inserted into the spreadsheet. |
| 06:08 | So, double-click on the chart so that it is enclosed by a gray border |
| 06:13 | indicating that it is in the Edit mode. |
| 06:18 | Now, click on the Format option in the main menu. |
| 06:22 | You see that the drop-down menu contains a number of formatting options like “Format Selection”, “Position and Size”, “Arrangement”, “Chart Wall” , “Chart Area” and many more. |
| 06:37 | They are used for positioning the chart, arranging and formatting the background and title of the chart. |
| 06:44 | We will learn about the most frequently used formatting options one by one. |
| 06:49 | The “Format Selection” option opens a dialog-box with the heading “Chart Area”. |
| 06:56 | Observe that there are 3 tabs here - “Borders”, “Area” and “Transparency”. |
| 07:03 | By default, “Borders” tab is selected. |
| 07:07 | Let us change the style and color of the chart’s border. |
| 07:11 | To do so, click on the “Style” field and choose “Continuous”. |
| 07:16 | Then, similarly in the “Color” field, click on “Green”. |
| 07:21 | Now, click on the OK button. |
| 07:26 | Notice that the style and color of the chart border change accordingly. |
| 07:31 | The Title option formats the title of the chart and its axes. |
| 07:36 | The Axis option formats the lines that create the chart |
| 07:41 | as well as the font of the text that appears on both the X and Y axes. |
| 07:46 | Explore all of these options on your own, later, in order to learn what they do. |
| 07:53 | Calc also provides an option for changing the background of the chart area. |
| 07:58 | The chart area is the area surrounding the chart graphic, including the main title and key. |
| 08:05 | To format the chart area, click on the Format option and select Chart Wall. |
| 08:12 | You see that a dialog-box appears with the heading "Chart-Wall”. |
| 08:17 | The “Style” field displays “Continuous”, as this was our last choice. |
| 08:22 | In the “Color” field, let’s click on “Red”. |
| 08:26 | We will also change the size to “0.20”cm. |
| 08:31 | Now click on the OK button. |
| 08:35 | You see that the style and color of the chart area change. <pause> |
| 08:41 | Next we will learn about how to resize and move elements in a chart. |
| 08:46 | For resizing a chart, click on the sample chart. |
| 08:51 | You see that green handles appear around the chart. |
| 08:54 | To increase or decrease the size of the chart, click and drag one of the markers in one of the four corners of the chart. |
| 09:03 | In order to move a chart, first click on the chart. |
| 09:07 | Now, hover the cursor anywhere over the chart. |
| 09:11 | The cursor turns to a hand. |
| 09:14 | Click and move the chart to the desired location. Now, release the mouse button. |
| 09:20 | You have moved the chart! |
| 09:24 | Next we will learn how to resize charts by using the “Position and Size” dialog-box. |
| 09:30 | Again, click on the chart. |
| 09:33 | Now, right-click on the chart and select “Position and Size” from the context menu. |
| 09:40 | The “Position and Size” dialog-box appears. |
| 09:44 | It has various fields that can set the 'X' and 'Y' positions of the chart as well as the width and height of the chart. |
| 09:52 | Let us set the 'X' coordinate to “1.00” and 'Y' coordinate to “0.83” for our chart. |
| 10:02 | Click on the OK button. |
| 10:04 | We see that the chart positions itself according to the set values within the chart area. |
| 10:12 | This brings us to the end of this Spoken Tutorial. |
| 10:16 | To summarize, we learned how to: create charts, edit and format them. |
| 10:21 | We also learnt how to resize and move the charts within the spreadsheet. |
| 10:27 | Comprehensive Assignment- |
| 10:29 | Open your spreadsheet “practice.ods”. |
| 10:34 | Insert a Pie chart for the data. |
| 10:37 | Resize and move the chart to the bottom right corner of the sheet. |
| 10:42 | Watch the video available at the following link. |
| 10:46 | It summarizes the Spoken Tutorial project. |
| 10:50 | If you do not have good bandwidth, you can download and watch it. |
| 10:54 | The Spoken Tutorial team: |
| 10:56 | Conducts workshops using spoken tutorials. |
| 11:00 | Gives certificates for those who pass an online test. |
| 11:04 | For more details, please write to:
contact at spoken hyphen tutorial dot org. |
| 11:11 | Spoken Tutorial project is a part of the Talk to a Teacher project. |
| 11:15 | It is supported by the National Mission on Education through ICT, MHRD, Government of India. |
| 11:23 | More information on this mission is available at: |
| 11:26 | spoken hyphen tutorial dot org slash NMEICT hyphen Intro. |
| 11:34 | This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd. Thanks for joining. |
