vba to create scatter chart with new range every day

[jalea148]

Col A has dates [date in row k > date in row k -1]. Col B & Col C has the values [on any date only one has a value; the other null].
Every day, Mon - Friday, new data added to bottom row.
Want to plot most recent 50 rows as a scatter chart.

 

[jalea148]

amended question:

Col A has dates [date in row k > date in row k -1]. Col B & Col C has the values [on any date only one has a value; the other null].
Every day, Mon - Friday, new data added to bottom row.
Want to plot most recent 50 rows as a scatter chart.

Maybe the simplest solution is to copy the most recent 50 row to D1:D50, E1:E50, F1:F50 and plot that. Would need sub for the copy.