I’m trying to get a sense of trends for each day of the week and then plot it against a moving average so I can get some context.

[jacquiejacuinde]

I have data on revenues for 1 month but need to see what the average was for each day of the week ( M, TU, W, TH, F, SA, SU) and then plotting it against a moving average. How can I go about doing this? I am having a hard time coming up with the correct formulas

Here is some sample data fr=or one month:

Tu	1-Aug​	251.25​
W	2-Aug​	490​
Th	3-Aug​	572.5​
F	4-Aug​	878.75​
Sa	5-Aug​	893.75​
Su	6-Aug​	1182.5​
M	7-Aug​	447.5​
Tu	8-Aug​	236.25​
W	9-Aug​	330​
Th	10-Aug​	258.75​
F	11-Aug​	462.5​
Sa	12-Aug​	905​
Su	13-Aug​	411.25​
M	14-Aug​	160​
Tu	15-Aug​	195​
W	16-Aug​	442.5​
Th	17-Aug​	395​
F	18-Aug​	521.25​
Sa	19-Aug​	938.75​
Su	20-Aug​	155​
M	21-Aug​	137.5​
Tu	22-Aug​	283.75​
W	23-Aug​	273.75​
Th	24-Aug​	366.25​
F	25-Aug​	615​
Sa	26-Aug​	1912.5​
Su	27-Aug​	828.75​
M	28-Aug​	238.75​
Tu	29-Aug​	591.25​
W	30-Aug​	388.75​
Th	31-Aug​	375​

 

[Joe4]

Welcome to the Board!

You should be able to use an AVERAGEIFS formula, using the day of the week code in the first column as your criteria.
See: AVERAGEIFS Function

 

[jacquiejacuinde]

Thank you! I guess where i am having confusion with this now, is how I would go about plotting it?

 

[Joe4]

I really don't do much with plotting or charts, so I probably don't have much to offer on that part of the problem.

 

[jacquiejacuinde]

No worries, i appreciate it!