Creating Charts and Graphs

1 Creating Charts and GraphsTitle: Creating Charts and edition: December 2004 First Englishedition:December and trademark and the Chart the chart the and resizing a and a background to a in the background of Charts and Calc lets you present data graphically in a chart, so that you can visuallycompare data series and view trends in the and trademark informationThe contents of this Documentation are subject to the Public Documentation License,Version (the "License"); you may only use this Documentation if you comply with theterms of this License. A copy of the License is available at: Original Documentation is Creating Charts and Graphs . The Initial Writer(s) of theOriginal Documentation is/are Linda Worthington 2004.

2 All Rights Reserved. (InitialWriter contact(s): The Initial Writer contact(s) is to report errors inthe documentation. For questions regarding how to use the software, subscribe to the UsersMail List and post your question there: )All trademarks within this guide belong to legitimate direct any comments or suggestions about this document to Peter Kupfer for his review of this and updatesVersionDateDescription of December 2004 First published Charts and GraphsiiInserting chartsInserting Calc offers a variety of different ways to chart or graph your Calc data. Anytime a chart is created, the chart AutoPilot is the spreadsheet and highlight (select) the data to be included in the chart. There aretwo ways to proceed after you have selected your data.

3 The first method (see Figure 1) isInsert > Chart:Figure 1. Selecting Insert ChartThe second method (see Figure 2) is to long-click (that is, hold down the left mouse buttonfor 1 second) on Insert Object to display the floating toolbar, then click on the Insert Chartbutton: Creating Charts and Graphs1 Inserting chartsFigure 2. Using the Insert Chart buttonUsing the Chart AutoPilotOnce Insert Chart is selected, the chart AutoPilot menu appears. (See Figure 3.) The firstdialog is used to define the data range, the labels, and the target sheet for the 3. Create a Chart AutoPilotData RangeThe data range selected should contain both the labels and the data. (See Figure 4.) If thedata range is selected when the AutoPilot is started, it will automatically be inserted in theRange input field.

4 If the AutoPilot is started without a selected data range, a range can beselected by clicking on the range selection icon next to the Range input Charts and Graphs2 Inserting chartsFigure 4. Highlighted Data RangeFirst Row/Column as LabelFirst Row as Label: Uses the entries in the top row of the selection as labels for the datarange. This setting is useful if there are several columns of data that need to be displayed inthe same chart. (See Figure 5.)Figure 5. Example using first row as labelCreating Charts and Graphs3 Row 2 Row 3 Row 4 Row 5 Row 60123456789101st Row as LabelTime (s)Speed (m/s)Inserting chartsFirst Column as Label: Uses the entries in the leftmost column of the selection as labels forthe data range. (See Figure 6.)Figure 6.

5 Example using first column as labelFirst Column & First Row as Label: Both checkboxes can be selected as well. Thisprovides a combination of both options. This sets the first row as the labels and the firstcolumn as the x-axis values. (See Figure 7.)Figure 7. Example using first column and first row as labelsChart Results OutputThis dropdown box specifies which sheet the chart will output to. By default the currentsheet is selected, but any sheet, or a new sheet, can also be selected. However, a chart can notbe set to be its own sheet; it must be an object in a normal the correct options have been input, either click Create to create the chart, or clickNext to proceed to the next dialog to choose the chart Charts and Graphs4 Time (s)123450123456789101st Column as LabelColumn B123450123456789101st Column & 1st Row as LabelSpeed (m/s)Inserting chartsChoosing the chart typeOn the next page of the AutoPilot (see Figure 8), the chart type can be chosen and a previewof the chart output can be seen.

6 Click Create from here, or click Next for more 8. Choosing a chart type (format) Calc offers several different chart types. Most chart types come in both a 2-dimensional and a 3-dimensional style. Below is the list of available styles with (2D & 3D) Provides a standard line graph that is useful for displaying changing dataover a period of Charts and Graphs5 Figure 9. 2D Line Graph: NormalFigure 10. 3D Line Graph: Deep102030405060050100150200250300350400 450500550600 Jenny's Distance (m)Marc's Distance (m)Sarah's Distance (m)Running DistancesJenny's Dis-tance (m)Marc's Distance (m)Sarah's Dis-tance (m)X axis titleY axis titleZ axis title10203040506005010015020025030035040 0450500550600 Running DistancesJenny's Distance (m)Marc's Distance (m)Sarah's Distance (m)Time (s)Distance (M)Inserting chartsAreas (2D & 3D) Creates Graphs that are similar to line Graphs but with the area under theline shaded (2D & 3D) Creates vertical columns to represent data.

7 The columns can benormal, stacked, or by percent. In 3D mode the data can also be represented by cylinders Charts and Graphs6 Figure 11. 2D Area: Stacked102030405060010020030040050060070 080090010001100120013001400 Running DistancesSarah's Dis-tance (m)Marc's Distance (m)Jenny's Dis-tance (m)Time (s)Distance (m)Figure 12. 3D Area: Deep102030405060050100150200250300350400 450500550600 Jenny's Distance (m)Marc's Distance (m)Running DistancesJenny's Dis-tance (m)Marc's Distance (m)Sarah's Dis-tance (m)Time (s)Distance (m)Figure 13. 2D Column: NormalSundayMondayTuesdayWednesdayThursd ayFridaySatur-day02040608010012014016018 0200# of CallsWeek 1 Week 2 Week 3 Day of the Week# of CallsFigure 14. 3D Columns: Cones, deepSundayTuesdayThursdayFridaySaturday0 30507090110130150170190 Week 1 Week 2 Week 3# of Calls by WeekWeek 1 Week 2 Week 3 Day of Week# of CallsInserting chartsBars (2D & 3D) Provides the same features as columns, but they are (2D & 3D) Graphs that are useful for showing the parts of a whole.

8 The pie chart canbe separated or keep as a solid Charts and Graphs7 Figure 15. 2D Bar: StackedSatur-dayFridayThursdayWednesdayT uesdayMondaySunday0100200300400500600# of CallsWeek 3 Week 2 Week 1 Day of the Week# of CallsFigure 16. 3D Bars: NormalSundayMondayTuesdayWednesdayThursd ayFridaySaturday050100150200# of Calls by WeekWeek 1 Week 2 Week 3 Day of Week# of CallsFigure 17. 2D Pie: Offset 2 Gases in the AtmosphereNitrogenOxygenCarbon DioxideArgonWater VaporOther GasesFigure 18. 3D Pie: NormalGases in the AtmosphereNitrogenOxygenCarbon DioxideArgonWater VaporOther GasesInserting chartsXY Chart This graph is similar to a scatter plot. It can be used to show several trials ofexperiments with two 19. XY Chart: Lines with SymbolsNet Provides a circular graph with a separate Y axis for each item on the X axis.

9 Pointswithin a data series are connected with a 20. Net Chart: NormalCreating Charts and of Different Masseswith a Given ForceAcceleration o f10kg mass(m/s2)Acceleration of 20kg mass(m/s2)Acceleration of 35kg mass(m/s2)Force (N)Acceleration (m/s^2)SundayMondayTuesdayWednesdayThurs dayFridaySaturday2000 Main TitleWeek 1 Week 2 Week 3 Inserting chartsStock Chart Shows change from one data series to the next for each X 21. Stock: Stock Chart 2 The next page of the AutoPilot (see Figure 22) provides options for fine-tuning the chartselection. There are several variants that can be chosen for each graph type. In the examplecharts above, the variants come after the colon. Again, the chart can be created from thisscreen, or titles and labels can be added by clicking 22.

10 Choosing a variantCreating Charts and Graphs9202122232427282930313456710111213 141718192021$ $ $ $ $ $ $ $ $ $ $ $ $ $ StocksWMTMSFTOOoDateValue (USD)Inserting chartsOn the last page of the AutoPilot (see Figure 23), a title and labels for the axes can be 23. Adding textEditing the chartOnce the chart is created, further edits can be made. To edit a chart:1) Select the chart (left-click).2) Right-click and select , the chart can be will activate a new toolbar on the left side of the screen (see Figure 24) used for editingdifferent aspects of the chart. Creating Charts and Graphs10 Editing the chartFigure 24. Edit Chart toolbarMoving and resizing a chartOnce the chart has been created, it can be moved or scaled. To move the chart:1) Click on the chart to select ) Click and hold down the left mouse button to drag the chart across the resize the chart:1) Click on the chart to select ) Click on one of the green handle bars (see Figure 25) and move the Charts and Graphs11 Editing the chartFigure 25.