2 Axes, same scale wanted
 

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?

2 Axes, same scale wanted
 

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/...nkToSheet.html

--
John Mansfield
http://cellmatrix.net





"jonny" wrote:

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?