On Fri, 15 Aug 2008, in microsoft.public.excel.charting,
epu said:
I'm trying to get the x axis to cross the y axis at zero for both the primary
and secondary y axis. However, since both sets of data points has negative
figures the x axis crosses the secondary y axis at a negative number. What
am I doing wrong?
You must make sure the two Y axes have maximum and minimum set to the
same proportion with respect to their zeroes. So if the primary Y axis
goes from -5 minimum to +10 maximum, and the secondary Y axis must have
a maximum of +4, then set its minimum to be -2. And so on.
--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.