« Basic functions: REPT | Main | Charting: Editing charts : part 2 »
November 30, 2004
Charting: Editing charts : part 1
In this series of tutorial, we will take a newly created chart and make use of the various chart editing tools provided by OOo Calc to adjust the appearance of the chart to our satisfaction.In the example below, the chart has just been created from the data in B2:C11 However, we would like to make some changes - making the chart background transparent, adjusting the orientation of the x-axis labels, changing the format of the y-axis numbers and correcting the label on the right hand side.
The first task is the chart background. We would like to make it transparent. We first select the chart by double (left) clicking inside it's borders. Then we invoke the Chart Area dialog by (right) clicking and selecting Chart Area as shown below.
With the Transparency tab selected, we make the desired change as shown below. Click OK
The end result is much more pleasing to the eye. But we are not finished yet with our chart modifications. Next, we will adjust the orientation of the x-axis labels.
To be continued...
Posted by Dave at November 30, 2004 03:28 AM
Comments
Does OOo Calc have a function like "COUNT" in MS Excel, that counts the cells containing data in a range? This is useful when creating a template that shows weekly information, which is averaged for the month. Since some months have 4 weeks and others have 5, it is convenient to use the COUNT function in Excel. I'd like to use it in Calc, too, if possible.
Thanks.
Posted by: Ray Craig at December 4, 2004 04:47 AM