If you double click the series there is an tab on the format dialog
which allows you to specify which axis to use.
The secondary y axis is displayed automatically. If you need the
secondary X axis see here
http://www.andypope.info/tips/tip008.htm
Cheers
Andy
BorisS wrote:
Thanks. And how do I get the second axis to work? In other words, by
clicking on the series which I want to convert from column to line, do I
select the custom column-line 2 axes type, and then it knows automatically
that I meant for the column on which I selected to be the line and the second
axis?
Thanks for the further clarification.
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info