Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
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   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Excel Chart Trendlines and percentages of increase or decrease

Yes, you can easily get the exact percentage of the overall trend rate when you trend data via Excel. Here are the steps to follow:
  1. First, create a chart in Excel with the data you want to trend.
  2. Next, add a trendline to the chart by right-clicking on one of the data points and selecting "Add Trendline."
  3. In the "Format Trendline" pane that appears on the right-hand side of the screen, select the "Trendline Options" tab.
  4. Under "Trendline Options," select the "Display Equation on chart" checkbox.
  5. The equation for the trendline will now appear on the chart. The equation will be in the form y = mx + b, where m is the slope of the trendline.
  6. To calculate the percentage increase or decrease of the trend rate, you need to divide the slope of the trendline by the initial value of the data and then multiply by 100.
  7. For example, if the equation for the trendline is y = 0.5x + 10 and the initial value of the data is 100, the percentage increase of the trend rate would be (0.5/100) x 100 = 0.5%.

That's it! You now know how to get the exact percentage of the overall trend rate when you trend data via Excel.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
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?



  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,104
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?



  #5   Report Post  
Posted to microsoft.public.excel.charting
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?


  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,104
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?



  #7   Report Post  
Posted to microsoft.public.excel.charting
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?




  #8   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
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?






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
increase/decrease decimal cbfinancial Excel Worksheet Functions 2 April 10th 06 10:43 PM
Excel formula that calculates percentage of increase or decrease Ration Excel Worksheet Functions 2 January 23rd 06 04:10 PM
% of increase or decrease Neil R Excel Discussion (Misc queries) 9 November 27th 05 03:13 AM
How do I set a cell that can increase but never decrease? Rich Excel Discussion (Misc queries) 2 November 2nd 05 06:04 PM
Value Increase/Decrease/No Change Michael Excel Worksheet Functions 1 November 5th 04 11:32 AM


All times are GMT +1. The time now is 07:55 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"