Thanks for your reply Andy - works fine.

"Andy Pope" wrote:

Hi Phil,

You need 2 data series in order to use a secondary axis.
That said the second data series can be formatted such that it does not
appear. If you use a copy of the original data the 2 Y axis will have
the same min and max values.

Cheers
Andy

Phil Hageman wrote:

Is it possible to have two Y Axes (one left and one right) with only one data
series?

Thanks,
Phil

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info