Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
lostinred
 
Posts: n/a
Default how do i chart a 24 month moving average of sales shipments

I need help creating a graph that shows a 24 month moving average of sales
shipments.
  #2   Report Post  
jahoobob
 
Posts: n/a
Default how do i chart a 24 month moving average of sales shipments


If your data is in column A, starting at A1, place this formula in B24:
=AVERAGE(A1:A24)
Copy this formula to the remaining cells down column B that have data
in column A
lostinred Wrote:
I need help creating a graph that shows a 24 month moving average of
sales
shipments.



--
jahoobob
  #3   Report Post  
lostinred
 
Posts: n/a
Default how do i chart a 24 month moving average of sales shipments

Thank you!

"jahoobob" wrote:


If your data is in column A, starting at A1, place this formula in B24:
=AVERAGE(A1:A24)
Copy this formula to the remaining cells down column B that have data
in column A
lostinred Wrote:
I need help creating a graph that shows a 24 month moving average of
sales
shipments.



--
jahoobob

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
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
track sales history by month for several years Kyle New Users to Excel 0 July 7th 05 06:46 PM
Label an average line in a dynamic chart John Cordes Charts and Charting in Excel 3 June 17th 05 09:42 AM
Plotting moving average line on a chart Herbert Chan Charts and Charting in Excel 1 February 26th 05 08:31 PM
Help with sales chart kim Charts and Charting in Excel 1 January 20th 05 02:38 PM


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

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

About Us

"It's about Microsoft Excel"