Dynamic Chart - X Axis Dates

[JohnZ1156]

I watched this YouTube video which was very helpful to create a dynamic "dropdown" list chart.

I modified it to allow me to specify different charts and select the last nth of data rows to appear in the chart.
I can't figure out how to get the dates to match the number of data rows.

Can anyone help me?

Here is a link to my sample file on Google Drive.
Dynamic Chart.xlsx

Thanks.

 

[JohnZ1156]

I can email you a link to my excel file.