View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
John Mansfield John Mansfield is offline
external usenet poster
 
Posts: 235
Default 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?