I have a chart which can have a range of up to 4000 points.
I frequent want to look at only a specific sub-range.
(Essentially zoom in on an area of interest.)

I wrote a macro which accepts starting and ending values from
particular cells.

I haven't figured out how to force it to run anytime I enter a new
value. If it replotted a 'new' range anytime the spreadsheet
recalculated, that would be fine also.

I could use keyboard shortcut.
BUT, computers should serve user, not vice versa:)

Thanks