Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Finding the slope of a trendline without a graph

Hi,
I have a large amount of data, it is a list of 2000 customer names with
each of their monthly sales for 12 months. I am trying to find an easy way of
ranking these customers based on their sales trend. My thought is adding a
column which shows the slope of their linear trendline. I can get the slope
if I use a graph but I am really just looking for the number. Can someone
help figure out how I can do this using Excel formulas? Thanks for your help.

--
Thank You,
Steve
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to link trendline equation in graph to cell? rossgus Excel Discussion (Misc queries) 2 May 11th 08 03:41 PM
Finding the slope of a trendline without a graph Steve D Excel Worksheet Functions 0 November 29th 06 04:00 PM
Finding the slope of a trendline without a graph Alok Excel Worksheet Functions 0 November 29th 06 03:53 PM
Trendline on stacked bar graph Joni Charts and Charting in Excel 1 February 19th 06 07:36 PM
Need to get slope of peaks on excel graph Capillod Charts and Charting in Excel 3 May 13th 05 03:16 PM


All times are GMT +1. The time now is 06:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"