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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|