Plot temperatures with F on one Y axis and C on another

[Brian]

I have a data series of temperatures

If I try to convert to C and plot on seperate axis, I have to play with
everything to get them to line up.

I want one data series with the F on one Y axis, and C on another Y axis.

Is this possible?

Thanks,

 

[David Biddulph]

Yes. Generate a dummy second series, & plot it. Format that to use a
secondary Y axis. Adjust the limits of the 2 Y axes to match each other
(e.g. 0 to 100 and 32 to 212). Make the second series invisible on the
chart.

 

[Brian]

David,

Thanks! Not the elegance I was hoping for, but the result is there!

 

[Jon Peltier]

Use a dummy axis along the right edge of the chart with an arbitrary set of
markers to simulate the axis. Less fudging to make it line up:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

So for example, a point will be plotted at 32, but its data label will read
zero.

- Jon