View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
rml rml is offline
external usenet poster
 
Posts: 50
Default Trendline Percent

It should be a small increase of say 2% or so. Anyways, how would I convert
those equations to a percent?

Thanks.

"Bernard Liengme" wrote:

With an R² value that low, I would not trust any derived data.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"rml" wrote in message
...
I created a chart with a trendline. How can I figure out the percent of
increase from the formula generated from trendline?

y = 2.1973x + 3211.2
R² = 0.0046

Thanks!