Daniel Lewis has written on 3/28/2010 8:05 PM:
PJH wrote:
Andreas Saeger has written on 3/28/2010 3:58 PM:
PJH wrote:
OK, I want an x/y scatter chart with dates as the X-axis and several
Y-axes.
How do I do that?
Thanks.
"Open" the chart (double-click) and change the chart type.
That is the answer to how to get an x/y scatter chart.
How do I insure that A is the X-axis and the others are plotted on Y?
How do I set a scale for each variable plotted on Y?
How do I set a scale that begins with a number other than 0?
Thanks.
The following link is to Chapter 3: Charts and Graphs of the Calc
Guide. Why don't you use this link to download this chapter? It just
might answer your questions.
http://www.oooauthors.org/english/userguide3/calc3/cg3-published/cg3-ch3-charts-and-graphs-pdf/view
Already went through that. Helped a little but not much.
My first question comes up because sometimes after I've selected all the
cells I want plotted, column A is not the X-axis.
Never did get Object Properties to appear.
Here's what worked:
1) With A1 as the current cell, click on the "Chart" button in the
toolbar. With no cells selected, Calc will try to find the extent of the
data automatically, which is fine in this case.
2) Configure your chart with the steps that follow...
Chart Wizard Step 1: Chart type: XY (Scatter). Click "Next"
Chart Wizard Step 2: Data Range (defaults are ok here). Click "Next"
Chart Wizard Step 3: Data Series: Select the data sets (columns)
that you don't want and click the "Remove" button. At the end, you
should have only "Odometer" and "MPG" left. The first column (date) will
be used for the x values.
Click "Next"
Chart Wizard Step 3: Chart elements (defaults are ok here). Click
"Finish"
3) To get the MPG data on a separate axis, right-click on the data line
in the chart and choose "Format Data Series" Options > Align data series
to: Secondary axis
Now my only problem is that my first date in the table is 3/16/04 but
the origin of the X-axis is 1/14/04. Is there any way to make the X-axis
begin at my first data point?
Thanks.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
