Difference between revisions of "LibreOffice-Calc-on-BOSS-Linux/C3/Using-Charts-and-Graphs/English-timed"
From Script | Spoken-Tutorial
PoojaMoolya (Talk | contribs) (Created page with " {| Border=1 || '''Time''' ||'''Narration''' |- ||00:00 ||Welcome to the Spoken tutorial on LibreOffice Calc-Inserting Charts in spreadsheets. |- ||00:08 ||In this tutorial...") |
PoojaMoolya (Talk | contribs) |
||
(6 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | |||
{| Border=1 | {| Border=1 | ||
|| '''Time''' | || '''Time''' | ||
Line 6: | Line 5: | ||
|- | |- | ||
||00:00 | ||00:00 | ||
− | ||Welcome to the Spoken tutorial on LibreOffice Calc-Inserting Charts in spreadsheets. | + | ||Welcome to the '''Spoken tutorial''' on '''LibreOffice Calc- Inserting Charts in spreadsheets'''. |
|- | |- | ||
||00:08 | ||00:08 | ||
− | ||In this tutorial we will learn the following: | + | ||In this tutorial, we will learn the following: |
|- | |- | ||
||00:11 | ||00:11 | ||
− | ||Creating,Editing and Formatting Charts | + | ||Creating, Editing and Formatting Charts |
|- | |- | ||
||00:15 | ||00:15 | ||
− | ||Resizing and moving of Charts | + | ||Resizing and moving of Charts. |
|- | |- | ||
||00:18 | ||00:18 | ||
− | ||Here we are using GNU/Linux as our operating system and LibreOffice Suite version 3.3.4. | + | ||Here, we are using '''GNU/Linux''' as our '''operating system''' and '''LibreOffice Suite version 3.3.4'''. |
|- | |- | ||
||00:27 | ||00:27 | ||
− | ||So let us start learning about the various viewing options in LibreOffice Calc. | + | ||So, let us start learning about the various viewing options in '''LibreOffice Calc'''. |
|- | |- | ||
||00:33 | ||00:33 | ||
− | || | + | ||'''Chart'''s can be powerful ways to convey information to the reader. |
|- | |- | ||
Line 42: | Line 41: | ||
|- | |- | ||
||00:48 | ||00:48 | ||
− | ||Let us open our | + | ||Let us open our "personal finance tracker.ods" '''sheet'''. |
|- | |- | ||
Line 50: | Line 49: | ||
|- | |- | ||
||00:59 | ||00:59 | ||
− | ||We will click on the cell referenced as | + | ||We will click on the cell referenced as '''E3''' and type the amount as '''6500'''. |
|- | |- | ||
||01:06 | ||01:06 | ||
− | ||Now going down the column, we will type the amounts as | + | ||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 | ||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. |
|- | |- | ||
||01:31 | ||01:31 | ||
− | ||So click on the cell referenced as “F3” and type the amount as | + | ||So, click on the cell referenced as '''“F3”''' and type the amount as '''500'''. |
|- | |- | ||
||01:37 | ||01:37 | ||
− | ||Now going down this column, we will type the amounts as | + | ||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 | ||01:54 | ||
− | ||Let us now learn how to create a chart for this table. | + | ||Let us now learn how to create a chart for this '''table'''. |
|- | |- | ||
||01:58 | ||01:58 | ||
− | ||In order to create a chart, we have to first select the data to be included in the chart. | + | ||In order to create a '''chart''', we have to first select the data to be included in the chart. |
|- | |- | ||
||02:05 | ||02:05 | ||
− | ||So | + | ||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 | ||02:14 | ||
− | ||Now click on the | + | ||Now, click on the '''Insert''' option in the Menu bar and then click on the '''Chart''' option. |
|- | |- | ||
Line 91: | Line 89: | ||
|- | |- | ||
||02:27 | ||02:27 | ||
− | ||Simultaneously the "Chart Wizard" | + | ||Simultaneously the '''"Chart Wizard"''' dialog box opens up. |
|- | |- | ||
Line 99: | Line 97: | ||
|- | |- | ||
||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" | + | ||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 | ||02:55 | ||
− | ||By checking the | + | ||By checking the '''3D Look''' option, one can also get the chart display in three dimension. |
|- | |- | ||
||03:03 | ||03:03 | ||
− | || | + | ||Let's try these options. |
|- | |- | ||
||03:06 | ||03:06 | ||
− | ||We will click on the | + | ||We will click on the '''Bar''' option under the '''“Choose a chart type”''' field. |
|- | |- | ||
Line 123: | Line 121: | ||
|- | |- | ||
||03:19 | ||03:19 | ||
− | ||Similarly you can click on the other options like “Pie”, <pause> “Area”, <pause> “Bubble” <pause> | + | ||Similarly, you can click on the other options like '''“Pie”''', <pause> '''“Area”''', <pause> '''“Bubble”''' <pause> |
|- | |- | ||
||03:28 | ||03:28 | ||
− | ||and many other options under the | + | ||and many other options under the '''Choose a chart type''' field and get the required type of chart. |
|- | |- | ||
||03:35 | ||03:35 | ||
− | ||Under the | + | ||Under the '''Steps''' option, we have another option named '''“Data Range”'''. |
|- | |- | ||
Line 139: | Line 137: | ||
|- | |- | ||
||03:48 | ||03:48 | ||
− | ||The default option of plotting data is “Data series in columns”. | + | ||The default option of plotting data is '''“Data series in columns”'''. |
|- | |- | ||
||03:54 | ||03:54 | ||
− | ||We can change the way we want to plot the data | + | ||We can change the way we want to plot the data by using '''“Data series in rows”''' instead. |
|- | |- | ||
||04:02 | ||04:02 | ||
− | ||This is useful if you use a style of chart such as “Column” to display your data. | + | ||This is useful if you use a style of chart such as '''“Column”''' to display your data. |
|- | |- | ||
||04:10 | ||04:10 | ||
− | ||Lastly, you can choose whether to use the | + | ||Lastly, you can choose whether to use the '''“First row as label”''' |
− | + | ||
− | “First row as label” | + | |
|- | |- | ||
||04:17 | ||04:17 | ||
− | ||or “First column as label” | + | ||or '''“First column as label”''' |
|- | |- | ||
Line 165: | Line 161: | ||
|- | |- | ||
||04:27 | ||04:27 | ||
− | ||Then click on | + | ||Then click on '''Data series in column''' again. |
|- | |- | ||
||04:31 | ||04:31 | ||
− | ||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. | + | ||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:42 | ||04:42 | ||
− | ||And then editing the range “$A$1 is to $F$7” to “$A$1 is to $D$7” . | + | ||And then editing the range “$A$1 is to $F$7” to “$A$1 is to $D$7”. |
|- | |- | ||
||04:56 | ||04:56 | ||
− | ||Observe that the data under the heading “Received” | + | ||Observe that the data under the heading “Received” is no longer represented in the chart. |
|- | |- | ||
||05:03 | ||05:03 | ||
− | ||Next, | + | ||Next, let's see what '''“Data Series”''' does. |
|- | |- | ||
Line 189: | Line 185: | ||
|- | |- | ||
||05:14 | ||05:14 | ||
− | ||The “Add” and “Remove” buttons will allow us to add or remove rows of data from the chart. | + | ||The '''“Add”''' and '''“Remove”''' buttons will allow us to add or remove rows of data from the chart. |
|- | |- | ||
||05:21 | ||05:21 | ||
− | ||We can also re-order the data by using the “Up” and “Down” buttons. | + | ||We can also re-order the data by using the '''“Up”''' and '''“Down”''' buttons. |
|- | |- | ||
||05:27 | ||05:27 | ||
− | ||So after selecting what and how to represent data in the chart, click on the “Finish” button in the dialog box. | + | ||So, after selecting what and how to represent data in the chart, click on the '''“Finish”''' button in the dialog-box. |
|- | |- | ||
||05:35 | ||05:35 | ||
− | ||You see that the chart is inserted into the spreadsheet. | + | ||You see that the '''chart''' is inserted into the spreadsheet. |
|- | |- | ||
Line 209: | Line 205: | ||
|- | |- | ||
||05:44 | ||05:44 | ||
− | ||we will now learn how to format charts in LibreOffice Calc. | + | ||we will now learn how to '''format''' charts in LibreOffice Calc. |
|- | |- | ||
||05:49 | ||05:49 | ||
− | ||The “Format” menu has many options for formatting | + | ||The '''“Format”''' menu has many options for formatting |
|- | |- | ||
Line 221: | Line 217: | ||
|- | |- | ||
||05:57 | ||05:57 | ||
− | ||Let us format the chart we inserted into the spreadsheet. | + | ||Let us '''format''' the '''chart''' we inserted into the spreadsheet. |
|- | |- | ||
Line 229: | Line 225: | ||
|- | |- | ||
||06:06 | ||06:06 | ||
− | ||indicating that it is in the | + | ||indicating that it is in the '''Edit''' mode. |
|- | |- | ||
||06:11 | ||06:11 | ||
− | ||Now click on the | + | ||Now, click on the '''Format''' option in the main menu. |
|- | |- | ||
||06:15 | ||06:15 | ||
− | ||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. | + | ||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. |
|- | |- | ||
Line 249: | Line 245: | ||
|- | |- | ||
||06:42 | ||06:42 | ||
− | ||The “Format Selection” option opens a dialog box with the heading “Chart Area”. | + | ||The '''“Format Selection”''' option opens a dialog-box with the heading “Chart Area”. |
|- | |- | ||
||06:49 | ||06:49 | ||
− | ||Observe that there are 3 tabs here - “Borders”, “Area” and “Transparency”. | + | ||Observe that there are 3 tabs here - '''“Borders”, “Area”''' and '''“Transparency”'''. |
|- | |- | ||
||06:55 | ||06:55 | ||
− | ||By default | + | ||By default, '''Borders''' tab is selected. |
|- | |- | ||
Line 265: | Line 261: | ||
|- | |- | ||
||07:04 | ||07:04 | ||
− | ||To do so, click on the “Style” field and choose “Continuous”. | + | ||To do so, click on the '''“Style”''' field and choose '''“Continuous”'''. |
|- | |- | ||
||07:09 | ||07:09 | ||
− | ||Then similarly in the “Color” field click on “Green”. | + | ||Then, similarly in the '''“Color”''' field click on '''“Green”'''. |
|- | |- | ||
||07:13 | ||07:13 | ||
− | ||Now click on the | + | ||Now, click on the '''OK''' button. |
|- | |- | ||
Line 281: | Line 277: | ||
|- | |- | ||
||07:23 | ||07:23 | ||
− | ||The “Title” option formats the title of the chart and its axes. | + | ||The '''“Title”''' option formats the title of the chart and its axes. |
|- | |- | ||
||07:29 | ||07:29 | ||
− | ||The “Axis” option formats the lines that create the chart | + | ||The '''“Axis”''' option formats the lines that create the chart |
|- | |- | ||
Line 293: | Line 289: | ||
|- | |- | ||
||07:39 | ||07:39 | ||
− | ||Explore all of these options on your own later in order to learn what they do. | + | ||Explore all of these options on your own later, in order to learn what they do. |
|- | |- | ||
||07:46 | ||07:46 | ||
− | ||Calc also provides an option for changing the background of the chart area. | + | ||'''Calc''' also provides an option for changing the background of the chart area. |
|- | |- | ||
||07:50 | ||07:50 | ||
− | ||The chart area is the area surrounding the chart graphic, including the main title and key. | + | ||The '''chart area''' is the area surrounding the chart graphic, including the main title and key. |
|- | |- | ||
||07:58 | ||07:58 | ||
− | ||To format the chart area, click on the “Format” option and select “Chart Wall”. | + | ||To format the chart area, click on the '''“Format”''' option and select '''“Chart Wall”'''. |
|- | |- | ||
||08:05 | ||08:05 | ||
− | ||You see that a dialog box appears with the heading “Chart Wall”. | + | ||You see that a dialog-box appears with the heading '''“Chart Wall”'''. |
|- | |- | ||
||08:09 | ||08:09 | ||
− | ||The “Style” field displays “Continuous” as this was our last choice. | + | ||The '''“Style”''' field displays '''“Continuous”''' as this was our last choice. |
|- | |- | ||
||08:15 | ||08:15 | ||
− | ||In the “Color” field, let’s click on “Red”. | + | ||In the '''“Color”''' field, let’s click on '''“Red”'''. |
|- | |- | ||
Line 325: | Line 321: | ||
|- | |- | ||
||08:23 | ||08:23 | ||
− | ||Now click on the | + | ||Now click on the '''OK''' button. |
|- | |- | ||
||08:27 | ||08:27 | ||
− | ||You see that the style and color of the chart area changes. | + | ||You see that the style and color of the chart area changes. |
|- | |- | ||
Line 349: | Line 345: | ||
|- | |- | ||
||08:55 | ||08:55 | ||
− | ||In order to move | + | ||In order to move the chart, first click on the chart. |
|- | |- | ||
Line 361: | Line 357: | ||
|- | |- | ||
||09:06 | ||09:06 | ||
− | ||Click and move the chart to the desired location. Now, release the mouse button. | + | ||Click and move the chart to the desired location. Now, release the '''mouse button'''. |
|- | |- | ||
Line 369: | Line 365: | ||
|- | |- | ||
||09:17 | ||09:17 | ||
− | ||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. |
|- | |- | ||
||09:23 | ||09:23 | ||
− | ||Again, click on the chart. | + | ||Again, click on the '''chart'''. |
|- | |- | ||
||09:26 | ||09:26 | ||
− | ||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. |
|- | |- | ||
||09:32 | ||09:32 | ||
− | ||The “Position and Size” dialog box appears. | + | ||The '''“Position and Size”''' dialog box appears. |
|- | |- | ||
Line 393: | Line 389: | ||
|- | |- | ||
||09:55 | ||09:55 | ||
− | ||Click on the | + | ||Click on the '''OK''' button. |
|- | |- | ||
Line 405: | Line 401: | ||
|- | |- | ||
||10:08 | ||10:08 | ||
− | ||To summarize, we learned how to: | + | ||To summarize, we learned how to: Create charts, edit and format them. |
|- | |- | ||
||10:14 | ||10:14 | ||
− | ||We also learnt how to resize and move the charts within the spreadsheet. | + | ||We also learnt how to '''resize''' and move the charts within the spreadsheet. |
|- | |- | ||
||10:20 | ||10:20 | ||
− | ||Comprehensive Assignment | + | ||Comprehensive Assignment- |
|- | |- | ||
Line 425: | Line 421: | ||
|- | |- | ||
||10:30 | ||10:30 | ||
− | ||Resize and move the chart to the bottom right corner of the sheet | + | ||Resize and move the chart to the bottom right corner of the sheet. |
|- | |- | ||
||10:35 | ||10:35 | ||
− | ||Watch the video available at the following link | + | ||Watch the video available at the following link: |
|- | |- | ||
||10:39 | ||10:39 | ||
− | ||It | + | ||It summarizes the '''Spoken Tutorial''' project. |
|- | |- | ||
||10:43 | ||10:43 | ||
− | ||If you do not have good bandwidth, you can download and watch it | + | ||If you do not have good bandwidth, you can download and watch it. |
|- | |- | ||
||10:47 | ||10:47 | ||
− | ||The Spoken Tutorial Team | + | ||The Spoken Tutorial Team: |
|- | |- | ||
Line 449: | Line 445: | ||
|- | |- | ||
||10:53 | ||10:53 | ||
− | ||Gives certificates for those who pass an online test | + | ||Gives certificates for those who pass an online test. |
|- | |- | ||
||10:56 | ||10:56 | ||
− | ||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. |
|- | |- | ||
||11:03 | ||11:03 | ||
− | ||Spoken Tutorial Project is a part of the Talk to a Teacher project | + | ||'''Spoken Tutorial''' Project is a part of the '''Talk to a Teacher''' project. |
|- | |- | ||
||11:08 | ||11:08 | ||
− | ||It is supported by the National Mission on Education through ICT, MHRD, Government of India | + | ||It is supported by the National Mission on Education through ICT, MHRD, Government of India. |
|- | |- | ||
||11:15 | ||11:15 | ||
− | ||More information on this | + | ||More information on this mission is available at: spoken hyphen tutorial dot org slash NMEICT hyphen Intro. |
|- | |- | ||
||11:27 | ||11:27 | ||
− | ||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd | + | ||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd. |
− | + | Thanks for joining. |
Latest revision as of 15:23, 28 October 2020
Time | Narration |
00:00 | Welcome to the Spoken tutorial on LibreOffice Calc- Inserting Charts in spreadsheets. |
00:08 | In this tutorial, we will learn the following: |
00:11 | Creating, Editing and Formatting Charts |
00:15 | Resizing and moving of Charts. |
00:18 | Here, we are using GNU/Linux as our operating system and LibreOffice Suite version 3.3.4. |
00:27 | So, let us start learning about the various viewing options in LibreOffice Calc. |
00:33 | Charts can be powerful ways to convey information to the reader. |
00:38 | LibreOffice Calc offers a variety of charts 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:05 | 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 date 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 display in three dimension. |
03:03 | Let's try these options. |
03:06 | 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:41 | 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:17 | or “First column as label” |
04:22 | or both as labels on the axes of the chart. |
04:27 | Then click on Data series in column again. |
04:31 | 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:42 | And then editing the range “$A$1 is to $F$7” to “$A$1 is to $D$7”. |
04:56 | Observe that the data under the heading “Received” is no longer represented in the chart. |
05:03 | Next, let's see what “Data Series” does. |
05:08 | Notice there are 5 rows here, representing the total rows of data in our spreadsheet. |
05:14 | The “Add” and “Remove” buttons will allow us to add or remove rows of data from the chart. |
05:21 | We can also re-order the data by using the “Up” and “Down” buttons. |
05:27 | So, after selecting what and how to represent data in the chart, click on the “Finish” button in the dialog-box. |
05:35 | You see that the chart is inserted into the spreadsheet. |
05:40 | After learning about how to insert charts in spreadsheet, |
05:44 | we will now learn how to format charts in LibreOffice Calc. |
05:49 | The “Format” menu has many options for formatting |
05:53 | and fine-tuning the appearance of the charts. |
05:57 | Let us format the chart we inserted into the spreadsheet. |
06:00 | So, double-click on the chart so that it is enclosed by a gray border |
06:06 | indicating that it is in the Edit mode. |
06:11 | Now, click on the Format option in the main menu. |
06:15 | 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:30 | They are used for positioning the chart, arranging and formatting the background and title of the chart. |
06:36 | We will learn about the most frequently used formatting options one by one. |
06:42 | The “Format Selection” option opens a dialog-box with the heading “Chart Area”. |
06:49 | Observe that there are 3 tabs here - “Borders”, “Area” and “Transparency”. |
06:55 | By default, Borders tab is selected. |
07:00 | Let us change the style and color of the chart’s border. |
07:04 | To do so, click on the “Style” field and choose “Continuous”. |
07:09 | Then, similarly in the “Color” field click on “Green”. |
07:13 | Now, click on the OK button. |
07:18 | Notice that the style and color of the chart border changes accordingly. |
07:23 | The “Title” option formats the title of the chart and its axes. |
07:29 | The “Axis” option formats the lines that create the chart |
07:33 | as well as the font of the text that appears on both the X and Y axes. |
07:39 | Explore all of these options on your own later, in order to learn what they do. |
07:46 | Calc also provides an option for changing the background of the chart area. |
07:50 | The chart area is the area surrounding the chart graphic, including the main title and key. |
07:58 | To format the chart area, click on the “Format” option and select “Chart Wall”. |
08:05 | You see that a dialog-box appears with the heading “Chart Wall”. |
08:09 | The “Style” field displays “Continuous” as this was our last choice. |
08:15 | In the “Color” field, let’s click on “Red”. |
08:19 | We will also change the size to “0.20”cm. |
08:23 | Now click on the OK button. |
08:27 | You see that the style and color of the chart area changes. |
08:34 | Next we will learn about how to resize and move elements in a chart. |
08:39 | For resizing a chart, click on the sample chart. |
08:44 | You see that green handles appear around the chart. |
08:47 | 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. |
08:55 | In order to move the chart, first click on the chart. |
09:00 | Now hover the cursor anywhere over the chart. |
09:04 | The cursor turns to a hand. |
09:06 | Click and move the chart to the desired location. Now, release the mouse button. |
09:13 | You have moved the chart! |
09:17 | Next we will learn how to resize charts by using the “Position and Size” dialog box. |
09:23 | Again, click on the chart. |
09:26 | Now, right-click on the chart and select “Position and Size” from the context menu. |
09:32 | The “Position and Size” dialog box appears. |
09:36 | 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:45 | Let us set the 'X' coordinate to “1.00” “ and 'Y' coordinate to “0.83” “ for our chart. |
09:55 | Click on the OK button. |
09:57 | We see that the chart positions itself according to the set values within the chart area. |
10:04 | This brings us to the end of this Spoken Tutorial. |
10:08 | To summarize, we learned how to: Create charts, edit and format them. |
10:14 | We also learnt how to resize and move the charts within the spreadsheet. |
10:20 | Comprehensive Assignment- |
10:22 | Open your spreadsheet “practice.ods” |
10:26 | Insert a "Pie chart" for the data. |
10:30 | Resize and move the chart to the bottom right corner of the sheet. |
10:35 | Watch the video available at the following link: |
10:39 | It summarizes the Spoken Tutorial project. |
10:43 | If you do not have good bandwidth, you can download and watch it. |
10:47 | The Spoken Tutorial Team: |
10:49 | Conducts workshops using spoken tutorials. |
10:53 | Gives certificates for those who pass an online test. |
10:56 | For more details, please write to: contact at spoken hyphen tutorial dot org. |
11:03 | Spoken Tutorial Project is a part of the Talk to a Teacher project. |
11:08 | It is supported by the National Mission on Education through ICT, MHRD, Government of India. |
11:15 | More information on this mission is available at: spoken hyphen tutorial dot org slash NMEICT hyphen Intro. |
11:27 | This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.
Thanks for joining. |