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

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,
--
Brian

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

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.
--
David Biddulph

"Brian" wrote in message
...
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,
--
Brian

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

David,

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

--
Brian


"David Biddulph" wrote:

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.
--
David Biddulph

"Brian" wrote in message
...
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,
--
Brian

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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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.
--
David Biddulph

"Brian" wrote in message
...
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,
--
Brian