Line Chart -Print a selected period of time

[stans]

Hello,
I need some help with an Excel chart.
I have set up a line chart to track Glucose levels, indefinitely.
My problem is that my line chart is getting too long to be legible when I print it.
Is there an easy way to set it up so that I don’t have to reset my chart data each time I want to print, maybe within the workbook or VBA ?
Perhaps have a cell for a start date and an end date, or set it up to just print 3 weeks of data.
I wrestled a bit with a pivot table but it only charted my AM entries.
I would also like to ask, Did I set the data entry up properly, in order to be able to effectively chart the entries?
See attached

[sdckapr]

An easy way is to hide the rows you do not want to display, the graph will not have them...

You could also create dynamic ranges for the ranges:
DateTime
=OFFSET($C$1,MATCH(TODAY()-21,$C:$C,0)-1,0,44,3)
Levels
=OFFSET($F$1,MATCH(TODAY()-21,$C:$C,0)-1,0,44,1)

Which start 21 days before today and plots 22 days (this would include a Saturday thru Saturday. Thus the chart will be updated everyday...
Steve

PS note I forgot that each day was 2 rows...

[stans]

Thanks