"Shane Devenshire" wrote:

Hi,

Here are the steps in 2007 with your data set up as follows:

X1 X2 Data Data
1 1 3 72
2 4 39 68
3 9 70 75
4 16 42 36

If you are only plotting one series of Data, make up the other one, its just
dummy data.

1. Select the whole range and plot it.
2. Select the chart and choose Chart Tools, Design, Select Data, click the
X1 series and click Switch Row/Column. OK.
3. With the chart selected there will be a blue highlight around your data,
drag the bottom left blue square sizing handle to the right one column so you
outline the range C2:D5.
4. Right-click one of the series on the chart and choose Format Data
Series, on the Series Options tab pick Secondary Axis and click Close.
5. With one of the series selected the purple highlight will be around the
X1 data A2:A5. Put your mouse along the border until you see a white arrow
with four black arrows and drag the highlight to B2:B5.
6. Choose Chart Tools, Axis, Secondary Horizontal Axis, Show Default Axis.

Cleanup:
1. Delete the data in D1:D5
2. Select the Legend, then select the legend key for the "dead series" and
press delete.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"balhal" wrote:


I tried the solution and it's fine for data easily converted to a line
graph. I don't see how it can work with variable x data you often use for a
scatter plot. For the simple graph described, you can use a line graph and it
will be okay. But what if the original X data was something like 1, 1.2, 1.8,
4, 4.1 that you would like to see on a linear scale for the first graph.

Of course an obvious solution is to just use a set of text boxes, klugy but
workable I suppose.

Did I miss something I can do to use the suggested approach for a scatter
plot?

I probably am not making myself clear. The above approaches, which are
really clever, don't do what I need, I dont think, If the second scale was
linear, say X2 = 5 + X1, then they would work nicely. But, we have one linear
scale, 1,2,3,4 and one quadratic, 1,4, 9, 16. Doing what you suggest you can
get the second scale where the 1 and 1 match and the 4 and 16 match, but you
can't match up the 2 with the 4 and the 3 with the 9. Or can you in an XY
graph?