Create bar chart, dynamic cells, VBA macro

[bookworm121]

So I have a very simple worksheet. 2 columns A and B, a title in A1, and the data starts at A2 and continues for an unknown amount of rows that may vary.
I need to use the data and create a macro that would give me a bar chart regardless of how many rows are in the sheet.
It has to be VBA because its part of a larger piece of code.
Any help would be appreciated!

 

[Steve=True]

I typically make dynamic charts using a named range with the Offset function defining the formula for the named range. I don't use VBA, but i am sure you can add it to your script.