Excel Chart Trendlines and percentages of increase or decrease

N

no trend wizard

Does anyone know how to get the exact percentage of the overall trend rate
when you trend data via Excel?
 
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.
 
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?
 

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

Labeling on independently stacked line chart 0
Trendline partial data 2
Trendline in Stacked Column Chart 2
Creating a linear trend line in Excel 0
adding a line to show average for a data series on a chart 1
Chart percentage display needs to be neater 1
Turning off automatic calculation 0
Trendlines: When They Will Be Generated, And When They Will Not BeFor A Scatter Chart 0

Top