Macro to Make Chart out of Variable Ranges in a Table

I am new to Excel VBA and am trying to figure out how I can write VBA code to create a chart (a 2D Line with Markers chart) based on a table which will always have the same number of columns (A:G) but vary in the number of rows (8 to 10, 8 to 100, 8 to 1200, etc.).

I can't figure out how to get the chart to dynamically choose the number of rows for chat data based on the last row with data in it.

See attached image.

Any help? Thanks in advance!

Hello Quepes.

In your example, I would turn the grid into an actual "Table".

Select cell "A8".
From the menu ribbon, select INSERT/TABLE. Click the box My table has headers. Ok.

Now click from the ribbon, INSERT /LINE (choose the appropriate line graph).

the Resulting Graph is now Dynamically linked to the table.
If the table stretches, so does the graph.
If the the table shrinks, so does the graph.

Note that your row 8 will be the titles on the graph, so label them accordingly.