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

||Welcome to the Spoken tutorial on LibreOffice Calc-Inserting Charts in spreadsheets.

||In this tutorial we will learn the following:

||Creating,Editing and Formatting Charts

||Resizing and moving of Charts

||Here we are using Ubuntu Linux version 10.04 and  LibreOffice Suite version 3.3.4.  

||So let us start learning about the various viewing options in LibreOffice Calc.

||LibreOffice Calc offers a variety of charts formats for your data.

||We will click on the cell referenced as “E3” and type the amount as “6500”.

||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.

||So click on the cell referenced as “F3” and type the amount as “500”.

||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.

||Let us now learn how to create a chart for this table.

||In order to create a chart, we have to first select the data to be included in the chart.

||So Click on the cell“SN” and without releasing the mouse button, drag the cursor till the last cell which has “700” in it.

||Now click on the “Insert” option in the menubar and then click on the “Chart” option.

||Simultaneously the "Chart Wizard" dialogue box opens up.  

||This default chart updates to reflect the changes you make in the Chart Wizard.

||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.

||By checking the “3D Look” option, one can also get the chart display in three dimension.

||Lets try these options.

||We will click on the “Bar” option under the “Choose a chart type” field.  

||Similarly you can click on the other options like “Pie”, <pause> “Area”, <pause> “Bubble” <pause>

||and many other options under the “Choose a chart type field” and get the required type of chart.  

||Under the “Steps” option, we have another option named “Data Range”.

||The default option of plotting data is “Data series in columns”.

||We can change the way we want to plot the data, by using “Data series in rows” instead.  

||Lastly, you can choose whether to use the

 

“First row as label”

||or “First column as label”,

||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.

||Next, lets see what “Data Series” does.

||The “Add” and “Remove” buttons will allow us to add or remove rows of data from the chart.  

||We can also re-order the data by using the “Up” and “Down” buttons.  

||So after selecting what and how to represent data in the chart, click on the “Finish” button in the dialog box.  

||we will now learn how to format charts in LibreOffice Calc.

||The “Format” menu has many options for formatting

||indicating that it is in the “Edit” mode.  

||Now click on the “Format” option in the main menu.  

||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.

||The “Format Selection” option opens a dialog box with the heading “Chart Area”.

||Observe that there are 3 tabs here - “Borders”, “Area” and “Transparency”.

||By default “Borders” tab is selected.

||To do so, click on the “Style” field and choose “Continuous”.

||Then similarly in the “Color” field click on “Green”.

||Now click on the “OK” button.  

||The “Title” option formats the title of the chart and its axes.  

||The “Axis” option formats the lines that create the chart

||Explore all of these options on your own later in order to learn what they do.  

||Calc also provides an option for changing the background of the chart area.  

||To format the chart area, click on the “Format” option and select “Chart Wall”.

||You see that a dialog box appears with the heading “Chart Wall”.  

||The “Style” field displays “Continuous” as this was our last choice.  

||In the “Color” field, let’s click on “Red”.  

||We will also change the size to “0.20”cm.  

||Now click on the “OK” button.

||Next we will learn about how to resize and move elements in a chart.  

||Click and move the chart to the desired location. Now, release the mouse button.

||Next we will learn how to resize charts by using the “Position and Size” dialog box.  

||Now right-click on the chart and select “Position and Size” from the context menu.  

||The “Position and Size” dialog box appears.  

||Let us set the 'X' coordinate to “1.00” “ and 'Y' coordinate to “0.83” “ for our chart.

||Click on the “OK” button.  

||To summarize, we learned how to:  Create charts, edit and format them

||Comprehensive Assignment

||Open your spreadsheet “practice.ods”

||Resize and move the chart to the bottom right corner of the sheet

||Watch the video available at the following link  

||It summarises the Spoken Tutorial project  

||If you do not have good bandwidth, you can download and watch it  

||The Spoken Tutorial Team

||Conducts workshops using spoken tutorials.  

||Gives certificates for those who pass an online test  

||For more details, please write to contact at spoken hyphen tutorial dot org  

||Spoken Tutorial Project is a part of the Talk to a Teacher project  

||It is supported by the National Mission on Education through ICT, MHRD, Government of India  

||More information on this Mission is available at  

||spoken hyphen tutorial dot org slash NMEICT hyphen Intro  

||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd  

    Thanks for joining