LibreOffice-Calc-on-BOSS-Linux/C3/Using-Charts-and-Graphs/English

From Script | Spoken-Tutorial
Jump to: navigation, search

Resources for recording

Using Charts and graphs in Calc

VISUAL CUE NARRATION
Show Slide Number 1

Title Slide Using Charts in Calc.

Welcome to the

Spoken tutorial on LibreOffice Calc - Inserting Charts in spreadsheets.

Show Slide Number 2

Learning Objectives

  • Creating, editing and formatting Charts
  • Resizing and moving Charts
In this tutorial we will learn the following:


  • Creating, editing and formatting charts
  • Resizing and moving charts
Show Slide Number 3

Here we are using

  • GNU/Linux
  • LibreOffice Suite version 3.3.4

Here we are using

  • GNU/Linux and
  • LibreOffice Suite version 3.3.4
So let us start learning about the various viewing options in LibreOffice Calc.
Show Slide Number 4

Charts

  • Powerful ways to convey

information to the reader

  • Variety of Chart formats for your data.
  • Customize Charts to a

considerable extent, too.

  • Charts can be powerful ways to convey information to the reader.
  • LibreOffice Calc offers a variety of charts formats for your data.
  • Using Calc, you can customize charts to a considerable extent, too.
Open “Personal-Finance-Tracker.ods” Let us open our “Personal-Finance-Tracker.ods” sheet.
Click on column “E1”-> that is 'Spent' And let us fill the amount spent on each of the items listed in the sheet.
Click on “E3” that is “6500”. We will click on the cell referenced as “E3” and type the amount as “6500”.
Type “1000” in “E4”

Type “625” in “E5” Type “310” in “E6” Type “2700” in “E7”

Now going down this column, we will type the amounts as “1000”, “625”, “310” and “2700” in cells referenced as “E4, “E5”, “E6” and “E7” respectively.
Click on column “F1” that is “Received” Next we shall fill the amounts received on each of the items listed in the sheet.
Click on “F3” and type “500”. So we click on the cell referenced as “F3” and type the amount as “500”.
Type “200” in ““F4”

Type “75” in ““F5” Type “10” in “F6 Type “700” in “F7”

Now going down this column, we will type the amounts as “200”, “75”, “10” and “700” in 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.

Click on cell “SN”->hold down mouse button and select cells till the cell having “700” in it.

So click on the cell “SN” and without releasing the mouse-button,

drag the cursor till the last cell which has “700” in it.

Click on “Insert”->click on “Chart” Now click on the “Insert” option in the menu bar and then click on the “Chart” option.
Point to the default chart.

You could move the “Chart Wizard” dialog box to a corner of the screen in order to show the sample chart on the screen.

You see that the default chart with the data is inserted into the worksheet.
If you moved the “Chart Wizard” dialog box to a corner, then bring it to focus now.

Point to the “Chart Wizard” dialog box

Simultaneously, a “Chart Wizard” dialog box opens up.

Point to the “Normal” thumbnail on the right side. The Chart Wizard shows that the default chart is selected.
Point to the default chart.

Point to the “Chart Wizard” dialog box.

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


Point to “Steps”. Point to “Choose a chart type”. Point to the thumbnails on the right side.

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.
Point to “3D Look” and check the box. By checking the “3D Look” option, one can also get the chart display in three dimension.

Click on “Choose a chart type” >> “Bar”.

Lets try these options.

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

Point to sample chart which gives the preview. Observe that the sample chart shows the representation of the data in the table in the “Bar” format.
Point to “Pie”,”Area”,”Bubble” under the “Choose a chart type field” and the corresponding change on the sample chart. Similarly you can click on 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.

Point to “Steps” >> click on “Data Range”. Under the “Steps” option, we have another option named “Data Range”.

Using this option, you can manually edit the range of data you want to represent in the chart.

Point to “Data series in columns” >> Click on “Data series in rows” 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.

Click on “Choose a chart type” >>“Column” This is useful if you use a style of chart such as “Column” to display your data.
Check “First row as label” and uncheck

“First column as label”>> uncheck “First row as label” Point to the corresponding change in the sample chart. Check “First column as label”. Check “First row as label” again. Point to the corresponding change in the sample chart. Then click on data series in column again.

Lastly, you can choose whether to use the

“First row as label”

or “First column as label”,

or both as labels on the axes of the chart.

<pause>

Then click on data series in column again.

Click on “Data Range”->change “F” to “D” in 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.

And then editing the range “$A$1 is to $F$7” to “$A$1 is to $D$7” .

Point to sample chart which shows the preview Observe that the data under the heading “Received”, is no longer represented in the chart. <pause>
Point to “Data Series” >> click on it. Next, lets see what “Data Series” does.
Point to “Data Series” list in the middle. Notice there are 5 rows here, representing the total rows of data in our spreadsheet.
Point to the “Add” and “Remove” buttons. The “Add” and “Remove” buttons will allow us to add or remove rows of data from the chart.
Click on 3 >> click on the “Up” button and then on the “Down” button. We can also re-order the data by using the “Up” and “Down” buttons.

Click on “Finish”

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

Click anywhere in the spreadsheet.

You see that the chart is inserted into the spreadsheet.
After learning about how to insert charts in spreadsheet,

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

Point to “Format” in the main menu The “Format” menu has many options for formatting

and fine-tuning the appearance of the charts.

Double click on the chart >> point to the gray border around it.

Let us format the chart we inserted into the spreadsheet.

So, double-click on the chart so that it is enclosed by a gray border

indicating that it is in the “Edit” mode.

Click on “Format” in the main menu. Now click on the “Format” option in the main menu.
Scroll the cursor down the “Format” drop down 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.

They are used for positioning the chart, arranging and formatting the background and title of the chart.

We will learn about the most frequently used formatting options one by one.

Click on “Format Selection”->Point to “Chart Area”. The “Format Selection” option opens a dialog box with the heading “Chart Area”.
Point to the tabs “Borders”, “Area” and “Transparency” but don’t click any.

Point to “Borders” tab.

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

By default “Borders” tab is selected.


Click on “Style” >> choose “Continuous” Click on “Color” >> choose “Green”


Click on “OK”.


Let us change the style and color of the chart’s border.

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.

Click anywhere in the spreadsheet.

Point to the chart.

Notice that the style and color of the chart border changes accordingly.
Click on “Format” in the main menu.

Point to “Title” but don’t click.

The “Title” option formats the title of the chart and its axes.
Point to “Axis” but don’t click. The “Axis” option formats the lines that create the chart

as well as the font of the text that appears on both the X and Y axes.

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.
Point to the background of the sample chart >> then to the main title and then the key. The chart area is the area surrounding the chart graphic, including the main title and key.

Click on “Format”->click on “Chart Wall”.


Point to “Chart Wall”.

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

Click on “Style”->choose “Continuous” The “Style” field displays “Continuous” as this was our last choice.
Click on “Color”->choose “Red” In the “Color” field, let’s click on “Red”.
Click on “Width” >> choose “0.20cm”. We will also change the size to “0.20”cm.
Click “OK”.

Point to chart. Click anywhere in the spreadsheet.

Now click on the “OK” button.

You see that the style and color of the chart area changes. <pause>

Next we will learn about how to resize and move elements in a chart.
Click on the chart. For resizing a chart, click on the sample chart.
Point to the green handles on the chart. You see that green handles appear around the chart.
Click on the handle and increase/decrease the size of the chart. 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.
Click on the chart. In order to move a chart, first click on the chart.
Hover the cursor over the chart. Now hover the cursor anywhere over the chart.

Click and move the chart to the left of the spreadsheet >> Release the mouse button.

The cursor turns to a hand.

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

You have moved the chart!

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

Right click on the chart->choose “Position and Size”

Again, click on the chart.

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

Point to “Position and Size” dialog box. The “Position and Size” dialog box appears.
Point to the 'X' and 'Y' positions.

Point to the “Width” and “Height” fields.

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.
Set 'X' coordinate to '1.00” '

Set 'Y' coordinate to '0.83” '

Click on “OK”

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

Click on the “OK” button.

Point to the sample chart in the spreadsheet. We see that the chart positions itself according to the set values within the chart area.
Show Slide number 5

SUMMARY

  • Create charts, edit and format them
  • Resize and move the charts.
This brings us to the end of this Spoken Tutorial.

To summarize, we learned how to:

  • Create charts, edit and format them
  • We also learnt how to resize and move the charts within the spreadsheet.
Show Slide number 6

Comprehensive Assignment

  • Open your spreadsheet "practice.ods
  • Insert a Pie Chart for the data
  • Resize and move the Chart to the

bottom right corner of the sheet

Comprehensive Assignment

  • Open your spreadsheet “practice.ods”
  • Insert a pie chart for the data.
  • Resize and move the chart to the

bottom right corner of the sheet.

Show About Slide

About the Spoken Tutorial Project

  • It summarises the Spoken Tutorial project
  • If you do not have good bandwidth, you can download and watch it
  • 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
Show About Slide

Spoken Tutorial Workshops

The Spoken Tutorial Project Team

  • Conducts workshops using spoken tutorials
  • Gives certificates for those who pass an online test
  • For more details, please write to contact@spoken-tutorial.org

The Spoken Tutorial Project 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
Show Acknowledgement Slide

Acknowledgements

  • 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 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
Show About the contributor Slide

About the Contributor

  • This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd
  • www.desicrew.in
  • Thanks for joining
  • This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd
  • Thanks for joining

Contributors and Content Editors

PoojaMoolya