color coordination between primary y and secondary y axis

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
 
S

Shane Devenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Chart question using two y axes 2
how can i plot two different y-axis graph with same x-axis 1
Exel - add vertical line to two axis graph 0
Y Axis Titles (Excel is clipping titles) 4
Coordinate secondary y axis to primary y axis 2
Excel chart does not start at zero. 1
Labeling Secondary x Axis 3
Chart distorts secondary axis when the x-axis is logarithmic 5

Top