I have a worksheet that contains numerical data in cells F5 to something
like F20 or similar (depending on the event).

The data is refreshed from an external source (the time interval can be
adjusted by me).

Would it be possible to produce a graph below the data that would
refresh itself at an intervals of about 30-60 seconds or something set
by me, so that I could have a visual representation of events?

TIA