LibreOffice-Suite-Calc-6.3/C3/Using-Charts-and-Graphics-in-Calc/English-timed

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.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 $A$1 is to $E$7 to $A$1 is to $D$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.10cm 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 Open Spreadsheet-Practice.ods file
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.

Contributors and Content Editors

PoojaMoolya