color coordination between primary y and secondary y axis

  • Thread starter Thread starter Q
  • Start date Start date
Q

Q

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.
 
Back
Top