Create Dynamic Chart for last 90 specific values

[Ironman]

Hi

The below is an extract from a log showing my most recent runs, that goes back many months. The log also includes non-running entries as shown.

Book1
	A	B	C	D	E
1	DATE	ROUTE	DISTANCE	TIME	PACE
2	Sun, 1 Jan 2023	ROUTE 1	9.2	2:03:22	13:25
3	Mon, 2 Jan 2023	ROUTE 2	9.2	2:06:23	13:44
4	Tue, 3 Jan 2023	OTHER (IB)
5	Wed, 4 Jan 2023	ROUTE 3	8.9	2:02:24	13:45
6	Thu, 5 Jan 2023	OTHER (IB)
7	Fri, 6 Jan 2023	ROUTE 4	11.4	2:25:51	12:48
8	Sat, 7 Jan 2023	OTHER (IB)
9	Sun, 8 Jan 2023	REST
10	Mon, 9 Jan 2023	ROUTE 5	12.1	2:37:11	12:59
11	Tue, 10 Jan 2023	OTHER (IB)
12	Wed, 11 Jan 2023	ROUTE 6	8.9	1:50:26	12:24
13	Thu, 12 Jan 2023	OTHER (IB)
Sheet1

Cell Formulas
Range	Formula
E2:E3	E2	=IF(C2>0,D2/C2,"")
E5,E12,E10,E7	E5	=D5/C5

I am trying to create a dynamic chart for the last 90 entries only where there is a value in Cols C, D and E, to display the data from Cols A, C and E.

My understanding of dynamic charts is limited and help would therefore be greatly appreciated.

Thank you.

 

[aaewalsh]

To create a dynamic chart for the last 90 entries with a value in Cols C, D and E, and display the data from Cols A, C and E, you can use a combination of the INDEX and COUNTIF functions in Excel. First, use the COUNTIF function to determine the last cell with a value in Col C, D and E, then use the INDEX function to reference the range of data for the chart, starting from this last cell and going up 90 rows. You can then create a chart using this dynamic range of data as the source. Note that the exact steps will depend on the version of Excel you are using and the format of your data.

 

[Ironman]

Thanks. It would be helpful to see how the 2 functions would be applied to the data I provided, using Microsoft 365.