udprocks Member Sep 27, 2014 #1 Dear All, Hope going all well here.... Can any one please help me with ctreating a good volume trend as per record receive and record transfer.... date wise... thank you. Attachments trend.xlsx 8.9 KB · Views: 5
Dear All, Hope going all well here.... Can any one please help me with ctreating a good volume trend as per record receive and record transfer.... date wise... thank you.
Hui Excel Ninja Staff member Sep 29, 2014 #4 I would simply add a linear trendline to a chart then read off the formula for the Line of Best Fit Y = -0.041X + 1748.7 NOTE I would use Blank cells instead of 0's for the weekends Using zeroes for the Weekends Using Blanks for the Weekends
I would simply add a linear trendline to a chart then read off the formula for the Line of Best Fit Y = -0.041X + 1748.7 NOTE I would use Blank cells instead of 0's for the weekends Using zeroes for the Weekends Using Blanks for the Weekends
udprocks Member Sep 29, 2014 #5 Hui said: I would simply add a linear trendline to a chart then read off the formula for the Line of Best Fit Y = -0.041X + 1748.7 View attachment 11181 NOTE I would use Blank cells instead of 0's for the weekends Using zeroes for the Weekends View attachment 11179 Using Blanks for the Weekends View attachment 11180 Click to expand... Dear Sir, Thank you for your reply , i am fresher for creating trends my knowledge is zero about trends can you please help me with this level if you have time , thank you for your support.
Hui said: I would simply add a linear trendline to a chart then read off the formula for the Line of Best Fit Y = -0.041X + 1748.7 View attachment 11181 NOTE I would use Blank cells instead of 0's for the weekends Using zeroes for the Weekends View attachment 11179 Using Blanks for the Weekends View attachment 11180 Click to expand... Dear Sir, Thank you for your reply , i am fresher for creating trends my knowledge is zero about trends can you please help me with this level if you have time , thank you for your support.
Hui Excel Ninja Staff member Sep 29, 2014 #6 Please read: http://chandoo.org/wp/2011/01/24/trendlines-and-forecasting-in-excel/ http://chandoo.org/wp/2011/01/26/trendlines-and-forecasting-in-excel-part-2/ + http://chandoo.org/wp/2011/01/27/trendlines-and-forecasting-in-excel-part-3/
Please read: http://chandoo.org/wp/2011/01/24/trendlines-and-forecasting-in-excel/ http://chandoo.org/wp/2011/01/26/trendlines-and-forecasting-in-excel-part-2/ + http://chandoo.org/wp/2011/01/27/trendlines-and-forecasting-in-excel-part-3/
udprocks Member Sep 29, 2014 #7 Hui said: Please read: http://chandoo.org/wp/2011/01/24/trendlines-and-forecasting-in-excel/ http://chandoo.org/wp/2011/01/26/trendlines-and-forecasting-in-excel-part-2/ + http://chandoo.org/wp/2011/01/27/trendlines-and-forecasting-in-excel-part-3/ Click to expand... Hallo sir, Thank you for ur time , actualy i have already read this but i think its little bit complicated for me..
Hui said: Please read: http://chandoo.org/wp/2011/01/24/trendlines-and-forecasting-in-excel/ http://chandoo.org/wp/2011/01/26/trendlines-and-forecasting-in-excel-part-2/ + http://chandoo.org/wp/2011/01/27/trendlines-and-forecasting-in-excel-part-3/ Click to expand... Hallo sir, Thank you for ur time , actualy i have already read this but i think its little bit complicated for me..
