Dear all
Apologies for cross-posting
On 22 February, I posted the following request:
"...I am in looking for a quick answer, as I do not have time to fish around too much myself. If anyone knows whether it is possible to use Excel, Minitab or SPSS to construct a 2D scatter-plot in which two dependent variables which have entirely different scales (the point to stress here) are represented by separate y-axes (one on the left and one on the right, say).
"I don't want to do a 3-D plot or a matrix plot, which I know at least one of these packages can cope with. The idea would be to have one type of symbol or colour to represent points corresponding to one dependent variable and another type of symbol or colour to represent points corresponding to the other dependent variable. The independent variable is time and the idea is to see if peaks in the plot for one dependent variable are preceded by peaks in the plot for the other dependent variable and to do so by means of the one graph. Failing this, I would just consider the option of having separate graphs for each dependent variable."
Many thanks for your kind assistance. "
Thank you to all those who kindly responded. In the end the following procedure in Excel was the successful one:
Plot response variables 1 and 2 on the one graph as though you think they should be on the same scale. Then on the graph itself right-click on the data series which you wish to be assigned a secondary axis. Choose 'Format Data Series' and then the button 'Axis'. Finally, choose 'Secondary Axis'.
It's very straightforward when you know how.
With the 'Custom Types' approach suggested by a few respondents, the result is not quite what I am after, as the orignal x-axis is not preserved.
I have not thus far received any promising suggestions re doing similar in Minitab or SPSS.
Regards
Margaret
---------------------------------
Yahoo! Cars NEW - sell your car and browse thousands of new and used cars online search now
---------------------------------
|