2 Axes, same scale wanted

[Guest]

Hi

Is it possible to set my second y axis so that the scale is identical to the
first y axis. (My chart needs to have 2 axes as one plots daily values and
one plots annual) but I find that excel automatically assigns diferent scales
to each?

 

[Guest]

This same reference should apply to dual axis charts. You can apply scales
to both primary and secondary axes using worksheet cells via Jon's
explanation below.

http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html