Hello

In Excel 2007, is there an easy way to color coordinate the series in
primary y-axis and secondary y-axis.

I meant the first series in the primary y-axis has the same color as the
first series in the secondary y-axis ...

Thanks,

Q

Hi,

You will need to set those manually or via VBA code. There is not such
option. However, you might be able to create a chart template with the
options set and build future charts from that template.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Q" wrote:

Hello

In Excel 2007, is there an easy way to color coordinate the series in
primary y-axis and secondary y-axis.

I meant the first series in the primary y-axis has the same color as the
first series in the secondary y-axis ...

Thanks,

Q