Macro to change range of Chart on Workbook Open

[mcraj12]

Hello Everyone,

I see how to run a macro once the Workbook gets opened. What I really need help on is updating the range of the charts through a macro.

The workbook i have attached is just a smaller template that will act as a test. There are definitely more than one charts, but for this test one chart is suffice.

Logic:

First I need to check all sheets in the workbook for if a chart exists. If chart doesn't exist, move to next sheet. If it does, the chart is already ranged to look at the proper columns on data. However, it is only looking at two rows on data. I want it to look at the data rows up to the rows that are populated. Fortunately, all columns will have the same number of rows. If you look on my Workbook attached, the 2nd sheet has a chart on it. if you right click and click select data, you will notice columnA and columnC selected with only 2 rows of data used. I want my macro to use the rows that are populated for that column. Please Please help!