Difference between revisions of "LibreOffice-Suite-Calc/C3/Using-Charts-and-Graphs/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(3 intermediate revisions by 3 users not shown)
Line 1: Line 1:
'''Resources for recording'''
 
[[Media:Using Charts and graphs in Calc .zip |Using Charts and graphs in Calc ]]
 
 
 
{| Border=1
 
{| Border=1
 
|| '''Time'''
 
|| '''Time'''
Line 16: Line 13:
 
|-
 
|-
 
||00:11
 
||00:11
||* Creating, editing and formatting charts
+
||Creating, editing and formatting '''chart'''s
  
 
|-
 
|-
 
||00:14
 
||00:14
||* Resizing and moving of charts.
+
||Resizing and moving of charts.
  
 
|-
 
|-
 
||00:18
 
||00:18
||Here, we are using '''Ubuntu Linux''' version '''10.04''' and '''LibreOffice Suite''' version '''3.3.4'''.  
+
||Here, we are using:
 +
'''Ubuntu Linux''' version '''10.04''' and
 +
'''LibreOffice Suite''' version '''3.3.4'''.  
  
 
|-
 
|-
Line 36: Line 35:
 
|-
 
|-
 
||00:37
 
||00:37
||'LibreOffice Calc' offers a variety of chart formats for your data.
+
||'''LibreOffice Calc''' offers a variety of '''chart format'''s for your data.
  
 
|-
 
|-
Line 44: Line 43:
 
|-
 
|-
 
||00:48
 
||00:48
||Let us open our 'personal finance tracker.ods' sheet.  
+
||Let us open our "personal finance tracker.ods" sheet.  
  
 
|-
 
|-
Line 61: Line 60:
 
|-
 
|-
 
||01:26
 
||01:26
||Next we shall fill the amounts received on each of the items listed in the sheet.
+
||Next, we shall fill the amounts received on each of the items listed in the sheet.
  
 
|-
 
|-
Line 89: Line 88:
 
|-
 
|-
 
||02:21
 
||02:21
||You see that the default chart with the date is inserted into the worksheet.  
+
||You see that the default chart with the data is inserted into the worksheet.  
  
 
|-
 
|-
 
||02:27
 
||02:27
||Simultaneously, the "Chart Wizard" dialogue-box opens up.  
+
||Simultaneously, the "Chart Wizard" dialog-box opens up.  
  
 
|-
 
|-
Line 101: Line 100:
 
|-
 
|-
 
||02:36
 
||02:36
||This default chart updates to reflect the changes you make in the 'Chart Wizard'.
+
||This default chart updates to reflect the changes you make in the '''Chart Wizard'''.
  
 
|-
 
|-
 
||02:42
 
||02:42
||The "Chart Wizard" dialogue-box has three main parts- the steps involved in setting up the chart, choice of chart types, and the options for each chart type.
+
||The "Chart Wizard" dialog-box has three main parts- the '''steps''' involved in setting up the chart, choice of '''chart type'''s and the options for each chart type.
  
 
|-
 
|-
 
||02:55
 
||02:55
||By checking the '''“3D Look”''' option, one can also get the chart display in three dimension.
+
||By checking the '''“3D Look”''' option, one can also get the chart displayed in three dimensions.
  
 
|-
 
|-
Line 121: Line 120:
 
|-
 
|-
 
||03:11
 
||03:11
||Observe that the sample chart shows the representation of the data in the table in the “Bar” format.  
+
||Observe that the sample chart shows the representation of the data in the table, in the “Bar” format.  
  
 
|-
 
|-
Line 129: Line 128:
 
|-
 
|-
 
||03:28
 
||03:28
||and many other options under the '''“Choose a chart type field”''' and get the required type of chart.  
+
||and many other options under the '''“Choose a chart type”''' field and get the required type of chart.  
  
 
|-
 
|-
Line 165: Line 164:
 
|-
 
|-
 
||04:34
 
||04:34
||Then click on data series in column again.  
+
||Then click on '''Data series in column''' again.  
  
 
|-
 
|-
Line 185: Line 184:
 
|-
 
|-
 
||05:15
 
||05:15
||Notice there are 5 rows here, representing the total rows of data in our spreadsheet.
+
||Notice, there are 5 rows here- representing the total rows of data in our spreadsheet.
  
 
|-
 
|-
Line 261: Line 260:
 
|-
 
|-
 
||07:07
 
||07:07
||Let us change the style and color of the chart’s border.
+
||Let us change the '''style''' and '''color''' of the chart’s border.
  
 
|-
 
|-
Line 269: Line 268:
 
|-
 
|-
 
||07:16
 
||07:16
||Then, similarly in the '''“Color”''' field, click on “Green”.
+
||Then, similarly in the '''“Color”''' field, click on '''“Green”'''.
  
 
|-
 
|-
 
||07:21
 
||07:21
||Now click on the '''OK''' button.  
+
||Now, click on the '''OK''' button.  
  
 
|-
 
|-
 
||07:26
 
||07:26
||Notice that the style and color of the chart border changes accordingly.  
+
||Notice that the style and color of the chart border change accordingly.  
  
 
|-
 
|-
Line 317: Line 316:
 
|-
 
|-
 
||08:22
 
||08:22
||In the '''“Color”''' field, let’s click on “Red”.  
+
||In the '''“Color”''' field, let’s click on '''“Red”'''.  
  
 
|-
 
|-
Line 329: Line 328:
 
|-
 
|-
 
||08:35
 
||08:35
||You see that the style and color of the chart area changes. <pause>  
+
||You see that the style and color of the chart area change. <pause>  
  
 
|-
 
|-
 
||08:41
 
||08:41
||Next we will learn about how to '''resize''' and move elements in a chart.  
+
||Next we will learn about how to '''resize''' and move '''element'''s in a chart.  
  
 
|-
 
|-
Line 341: Line 340:
 
|-
 
|-
 
||08:51
 
||08:51
||You see that green handles appear around the chart.  
+
||You see that green '''handle'''s appear around the chart.  
  
 
|-
 
|-
 
||08:54
 
||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.
+
||To increase or decrease the size of the chart, click and drag one of the '''marker'''s in one of the four corners of the chart.
  
 
|-
 
|-
Line 353: Line 352:
 
|-
 
|-
 
||09:07
 
||09:07
||Now hover the cursor anywhere over the chart.  
+
||Now, hover the cursor anywhere over the chart.  
  
 
|-
 
|-
Line 369: Line 368:
 
|-
 
|-
 
||09:24
 
||09:24
||Next we will learn how to resize charts by using the '''“Position and Size”''' dialog-box.  
+
||Next we will learn how to '''resize''' charts by using the '''“Position and Size”''' dialog-box.  
  
 
|-
 
|-
Line 377: Line 376:
 
|-
 
|-
 
||09:33
 
||09:33
||Now right-click on the chart and select '''“Position and Size”''' from the context menu.  
+
||Now, right-click on the chart and select '''“Position and Size”''' from the context menu.  
  
 
|-
 
|-
Line 405: Line 404:
 
|-
 
|-
 
||10:16
 
||10:16
||To summarize, we learned how to:  Create charts, edit and format them.
+
||To summarize, we learned how to:  '''create''' charts, '''edit''' and '''format''' them.
 
    
 
    
 
|-
 
|-
Line 421: Line 420:
 
|-
 
|-
 
||10:34
 
||10:34
||Insert a "Pie chart" for the data.
+
||Insert a '''Pie chart''' for the data.
  
 
|-
 
|-
Line 445: Line 444:
 
|-
 
|-
 
||10:56
 
||10:56
||* Conducts workshops using spoken tutorials.  
+
||Conducts workshops using spoken tutorials.  
  
 
|-
 
|-
 
||11:00
 
||11:00
||* Gives certificates for those who pass an online test.  
+
||Gives certificates for those who pass an online test.  
  
 
|-
 
|-
 
||11:04
 
||11:04
||For more details, please write to: contact at spoken hyphen tutorial dot org.  
+
||For more details, please write to:
 +
'''contact at spoken hyphen tutorial dot org'''.  
  
 
|-
 
|-
Line 469: Line 469:
 
|-
 
|-
 
||11:26
 
||11:26
||spoken hyphen tutorial dot org slash NMEICT hyphen Intro.  
+
||'''spoken hyphen tutorial dot org slash NMEICT hyphen Intro'''.  
  
 
|-
 
|-
 
||11:34
 
||11:34
||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.  
+
||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd. Thanks for joining.
Thanks for joining.
+

Latest revision as of 14:40, 28 October 2020

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.

Contributors and Content Editors

Minal, PoojaMoolya, Pratik kamble, Sandhya.np14