PDA

View Full Version : Trendline for y-values



Polarfranz
05-04-2016, 04:57 AM
Hello,

I would like to create a Trendline for the y-values of my Graphs. Is it possible to do that?
And can I put multiple trendlines in one graph? Like one trendline for the first 6 values, an other one for the next 20 and one for the last 10? (These are just randomly picked numbers)

Regards,
Franz

Kenneth Hobs
05-04-2016, 12:59 PM
Do you mean by VBA code or manual? Of course there are many tutorials to do the latter. Search for "microsoft excel multiple trend lines".

If the former, one would just record a macro for each step and modify to suit.