Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
|
|||
|
|||
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:
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
increase/decrease decimal | Excel Worksheet Functions | |||
Excel formula that calculates percentage of increase or decrease | Excel Worksheet Functions | |||
% of increase or decrease | Excel Discussion (Misc queries) | |||
How do I set a cell that can increase but never decrease? | Excel Discussion (Misc queries) | |||
Value Increase/Decrease/No Change | Excel Worksheet Functions |