View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Trendline - 2nd Y axis

I have just (in the last 3 mins) made an XY chart with x from 1 to 10, y =
2*x and z=1000*x+500
Gave z a secondary axis
Gave each of y and z a trendline and the equations are correct.
So yes, you can
I am not being rude, just curious. Did you try a simple experiment and have
trouble getting two trendlines?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"JDB" < wrote in message
...
Does the trendline feature only work from the primary Y axis or can I
get a trendline based on the 2nd Y axis.

Thanks

JDB