A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel Chart Trendlines and percentages of increase or decrease



 
 
Thread Tools Display Modes
  #1  
Old September 14th, 2009, 06:30 PM posted to microsoft.public.excel.charting
no trend wizard
external usenet poster
 
Posts: 1
Default Excel Chart Trendlines and percentages of increase or decrease

Does anyone know how to get the exact percentage of the overall trend rate
when you trend data via Excel?
  #2  
Old September 14th, 2009, 06:49 PM posted to microsoft.public.excel.charting
David Biddulph
external usenet poster
 
Posts: 8,714
Default Excel Chart Trendlines and percentages of increase or decrease

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

"no trend wizard" no trend wrote in
message ...
Does anyone know how to get the exact percentage of the overall trend rate
when you trend data via Excel?



  #3  
Old September 14th, 2009, 07:39 PM posted to microsoft.public.excel.charting
Bernard Liengme[_2_]
external usenet poster
 
Posts: 1,027
Default Excel Chart Trendlines and percentages of increase or decrease

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


"no trend wizard" no trend wrote in
message ...
Does anyone know how to get the exact percentage of the overall trend rate
when you trend data via Excel?



  #4  
Old September 14th, 2009, 07:48 PM posted to microsoft.public.excel.charting
no trend wizard[_2_]
external usenet poster
 
Posts: 2
Default Excel Chart Trendlines and percentages of increase or decrease

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?
  #5  
Old September 14th, 2009, 07:54 PM posted to microsoft.public.excel.charting
Bernard Liengme[_2_]
external usenet poster
 
Posts: 1,027
Default Excel Chart Trendlines and percentages of increase or decrease

Multiply the slope by 100?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"no trend wizard" wrote in message
...
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?



  #6  
Old September 14th, 2009, 10:02 PM posted to microsoft.public.excel.charting
no trend wizard[_2_]
external usenet poster
 
Posts: 2
Default Excel Chart Trendlines and percentages of increase or decrease

How do your figure the slope? Isn't there somewhere in EXCEL??

"Bernard Liengme" wrote:

Multiply the slope by 100?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"no trend wizard" wrote in message
...
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?




  #7  
Old September 14th, 2009, 11:25 PM posted to microsoft.public.excel.charting
David Biddulph
external usenet poster
 
Posts: 8,714
Default Excel Chart Trendlines and percentages of increase or decrease

What did you find when you asked Excel help about slope?
--
David Biddulph

"no trend wizard" wrote in message
...
How do your figure the slope? Isn't there somewhere in EXCEL??

"Bernard Liengme" wrote:

Multiply the slope by 100?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"no trend wizard" wrote in
message
...
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?






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.