Dynamic rolling excel charts

[irrek100]

Can anyone PLEASE HELP ME!
Ive been struggling with this all morning.
I am trying to create a dynamic excel chart that always shows last 12 months. I have watched multiple tutorials, multiple times, it can not get it to work.
If anyone can please tell me where I am gong wrong, I would be extremely grateful.
I wish I could attach the file here, but I cant!
Thank you

 

[kevin9999]

Not 100% with you, but if you mean automatically adjust your data source for the chart based on the current month

always shows last 12 months

then you can use this (note the unique formula in A14, and the other same formula in A2:A13)

Book1
	A	B	C
1	Date	Capacity	Target
2	1/08/2022	82	96
3	1/09/2022	83	96
4	1/10/2022	85	96
5	1/11/2022	90	96
6	1/12/2022	100	96
7	1/01/2023	95	96
8	1/02/2023	90	96
9	1/03/2023	85	96
10	1/04/2023	95	96
11	1/05/2023	100	96
12	1/06/2023	105	96
13	1/07/2023	105	96
14	1/08/2023	100	96
Sheet3

Cell Formulas
Range	Formula
A2:A13	A2	=EDATE(A3,-1)
A14	A14	=EOMONTH(TODAY(),-1)+1

Alternatively, if you wanted the latest month with data to be specific (you've used January 2023) then you only need to adjust the formula in A14 as shown here:

Book1
	A	B	C
1	Date	Capacity	Target
2	1/01/2022	82	96
3	1/02/2022	83	96
4	1/03/2022	85	96
5	1/04/2022	90	96
6	1/05/2022	100	96
7	1/06/2022	95	96
8	1/07/2022	90	96
9	1/08/2022	85	96
10	1/09/2022	95	96
11	1/10/2022	100	96
12	1/11/2022	105	96
13	1/12/2022	105	96
14	1/01/2023	100	96
Sheet3

Cell Formulas
Range	Formula
A2:A13	A2	=EDATE(A3,-1)
A14	A14	=EOMONTH(TODAY(),-8)+1

In both cases, the months will adjust automatically. If you wanted the data to be drawn from another source, then you'll need to provide a lot more information.