Automatically update graph range based on date in column

I want a macro that will check each cell from A2 downwords and once the date = today or higher i.e. the latest to extend the maximum range of a chart.....

Please Login or Register  to view this content.

I know theres alot wrong in the above, but hopefully it gives you the general jist