N
no trend wizard
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?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Excel Chart Trendlines and percentages of increase or decrease
D
David Biddulph
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.
format as percentage.
If you are wanting to calculate a different percentage, modify the formula
accordingly.
B
Bernard Liengme
Do you mean the slope of the line?
Look at SLOPE function
best wishes
Look at SLOPE function
best wishes
N
no trend wizard
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?
B
Bernard Liengme
Multiply the slope by 100?
N
no trend wizard
How do your figure the slope? Isn't there somewhere in EXCEL??