Chart that shows individual performance vs group (relative dates)

[soccer4ward]

Hello,

Hoping I could get assistance in creating a chart. I have a table with the following data: Date, Name, Total
I have a line chart that allows you to view Total trend by agent and by date or date range. What i would like, is to add an average line that's based on ALL of the Names but is still within the selected "date" range. Basically the chart shows an individual's performance, vs entire table's average based on dates selected.

I don't have much experience with charts, but i did fine that i could add an "average" trend line...however, that trend line just shows me a running average for the name i have selected (based on X number of periods). Is there a way to edit that average line to show average for the whole set of data, not just the selected Name?

 

[awoohaw]

Try something like this:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Date	Name	Total
2	2023-01-01	Name1	3
3	2023-01-01	Name2	4			2023-01-01	2023-02-01	2023-03-01	2023-04-01	2023-05-01	2023-06-01	2023-07-01
4	2023-01-01	Name3	4		All	4.17	3.67	3.00	3.67	3.67	3.17	3.67
5	2023-01-01	Name4	5		Name3	4	2	2	2	4	3	5
6	2023-01-01	Name5	5
7	2023-01-01	Name6	4
8	2023-02-01	Name1	5
9	2023-02-01	Name2	3
10	2023-02-01	Name3	2
11	2023-02-01	Name4	4
12	2023-02-01	Name5	4
13	2023-02-01	Name6	4
14	2023-03-01	Name1	2
15	2023-03-01	Name2	4
16	2023-03-01	Name3	2
17	2023-03-01	Name4	3
18	2023-03-01	Name5	3
19	2023-03-01	Name6	4
20	2023-04-01	Name1	3
21	2023-04-01	Name2	4
22	2023-04-01	Name3	2
23	2023-04-01	Name4	4
24	2023-04-01	Name5	4
25	2023-04-01	Name6	5
26	2023-05-01	Name1	5
27	2023-05-01	Name2	4
28	2023-05-01	Name3	4
29	2023-05-01	Name4	2
30	2023-05-01	Name5	5
31	2023-05-01	Name6	2
32	2023-06-01	Name1	2
33	2023-06-01	Name2	5
34	2023-06-01	Name3	3
35	2023-06-01	Name4	3
36	2023-06-01	Name5	3
37	2023-06-01	Name6	3
38	2023-07-01	Name1	5
39	2023-07-01	Name2	5
40	2023-07-01	Name3	5
41	2023-07-01	Name4	3
42	2023-07-01	Name5	2
43	2023-07-01	Name6	2
44
soccer4ward

Cell Formulas
Range	Formula
F3	F3	=A3
G3:L3	G3	=EDATE(F3,1)
F4:L4	F4	=AVERAGEIFS($C$2:$C$43,$A$2:$A$43,F$3)
F5:L5	F5	=AVERAGEIFS($C$2:$C$43,$A$2:$A$43,F$3,$B$2:$B$43,$E5)

 

[soccer4ward]

Yes, thank you! I was able to adjust formulas to show data on daily basis but you were an amazing help in pointing me in the right direction! thank you so much!

 

[awoohaw]

You're welcome. I was unsure of what you meant by dates. But, i understood you were looking more for a solo vs group line graph along a time line of sorts. The time intervals were non consequential and that you would be able to augment as needed. Which you did. Thanks for the feedback.


Best Wishes!!