« Average a range without highest and lowest values | Main | Basic Functions: HLOOKUP »
November 03, 2004
Charting : Introduction
A picture tells a thousand words. In this introduction to OOo Calc charting capabilities, we will create a simple chart as an illustration of the operation of the charting AutoPilot.Anytime you create a chart object in OpenOffice Calc, the AutoPilot is invoked.
After you select the data for which you wish to create a chart, there are two ways to proceed - both illustrated below.
You can select Insert - Chart
... or you can use the Insert Object floating toolbar.
When the charting autopilot is invoked, it has default settings already assigned which can be used to create a sheet at any stage of the process.
Normally, however, you will need to tweak the settings a little to achieve the desired chart layout and contents.
The first dialog allows us to define the data range, the labels and the target sheet for the chart.
When you are satisfied with the settings, hit Next to move to the next dialog, or Create to proceed immediately to chart creation. Until you hit Create in these series of dialogs, you will be able to return to previous dialogs for further adjustments.
The second dialog is straightforward. You can choose the chart type and also be able to see a preview of the output.
Based on the chart type you have selected, the third dialog allows you to refine certain aspects of the output chart. By selecting/unselecting the different options available you can observe how these effect the appearance of the chart.
Finally, we get to add titles to our chart and any axes we also wish to label.
Once created, we can move and scale the chart.
To be continued...
Posted by Dave at November 3, 2004 06:03 AM
Comments
thanks for the help
Posted by: Ed at February 1, 2006 04:19 PM