Hi all, need some help with what should be a simple chart.

Using Excel 2003, I have a worksheet with a rolling year of data,
months on row 1, series titles in A2:A4, values in B2:M4 and Annual
Total in Column N (data in N2:N4).

As the Annual Total is 12 times the average I want the Total to be
assigned to a second Value Axis on the right from the default Value
Axis on the left.

I have no problem setting a complete Series to a second value Axis, but
I want to set a category to the second axis. How can I do that?

Thanks.

--
Spence