ExcelBanter - how do i chart a 24 month moving average of sales shipments

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - how do i chart a 24 month moving average of sales shipments (https://www.excelbanter.com/charts-charting-excel/51120-how-do-i-chart-24-month-moving-average-sales-shipments.html)

lostinred

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.

jahoobob

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

lostinred

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

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