Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Excel Chart Trendlines and percentages of increase or decrease
955 views
Skip to first unread message
trend wizard@discussions.microsoft.com no trend wizard
Sep 14, 2009, 1:30:01 PM9/14/09
to
Does anyone know how to get the exact percentage of the overall trend rate
when you trend data via Excel?
when you trend data via Excel?
David Biddulph
Sep 14, 2009, 1:49:16 PM9/14/09
to
If you want to know what percentage B1 is of A1, use the formula =B1/A1 and
format as percentage.
If you are wanting to calculate a different percentage, modify the formula
accordingly.
--
David Biddulph
format as percentage.
If you are wanting to calculate a different percentage, modify the formula
accordingly.
--
David Biddulph
"no trend wizard" <no trend wiz...@discussions.microsoft.com> wrote in
message news:29C72517-AEB0-49C8...@microsoft.com...
Bernard Liengme
Sep 14, 2009, 2:39:29 PM9/14/09
to
Do you mean the slope of the line?
Look at SLOPE function
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
Look at SLOPE function
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"no trend wizard" <no trend wiz...@discussions.microsoft.com> wrote in
message news:29C72517-AEB0-49C8...@microsoft.com...
no trend wizard
Sep 14, 2009, 2:48:01 PM9/14/09
to
I have a chart in which I right click on the data set and select add
trendline. What I need to know is how can I determine the % of the
increase/decrease/slope of the line? I would like to tell my colleagues that
their volumes are trending upware by x% each month -- how do I do this?
trendline. What I need to know is how can I determine the % of the
increase/decrease/slope of the line? I would like to tell my colleagues that
their volumes are trending upware by x% each month -- how do I do this?
Bernard Liengme
Sep 14, 2009, 2:54:50 PM9/14/09
to
Multiply the slope by 100?
"no trend wizard" <notren...@discussions.microsoft.com> wrote in message
news:9B3CC243-FF9F-47A4...@microsoft.com...
no trend wizard
Sep 14, 2009, 5:02:01 PM9/14/09
to
How do your figure the slope? Isn't there somewhere in EXCEL??
David Biddulph
Sep 14, 2009, 6:25:52 PM9/14/09
to
What did you find when you asked Excel help about slope?
--
David Biddulph
--
David Biddulph
"no trend wizard" <notren...@discussions.microsoft.com> wrote in message
news:1D6E3DAE-35BD-4809...@microsoft.com...
0 new messages