Excel Chart Trendlines and percentages of increase or decrease

  • Thread starter Thread starter no trend wizard
  • Start date Start date
N

no trend wizard

Does anyone know how to get the exact percentage of the overall trend rate
when you trend data via Excel?
 
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.
 
Do you mean the slope of the line?
Look at SLOPE function
best wishes
 
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?
 
How do your figure the slope? Isn't there somewhere in EXCEL??
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Curve fitting with weighted trendline 1
Chart percentage display needs to be neater 1
Trendline in Stacked Column Chart 2
Trendline partial data 2
Trendline Issues 4
trendlines 1
Sine trendline in scatter? 4
adding a line to show average for a data series on a chart 1

Back
Top