Creating a Graph with an unknown amount of data

Hello!

I'm trying to create a bar graph using Macros, but the data range varies.

For example

The spreadsheet may have

Please Login or Register  to view this content.

or it may have

Please Login or Register  to view this content.

The data will be in the same columns. I just don't know how many rows of data there will be to set static values for the data range.

Thank you for any help