I am creating a report using VBA, every week it runs the report for the previous month and current month, so every week the number of rows increases.
I have a sheet that has a couple of graphs, these I created manually. I want to only show rows in graph that has data, so I would like it to be Dynamic.
For example first week of the month the data may only have 26 rows, but by the end of the month it could have 40 - If i choose A2:A40 the graph look strange as it is half empty with data and the other half empty. Is there a way to not show if the data is empty of to add the data to the graph dynamically so if there is 26 rows it shows 26, but if there is 35 rows it shows 35 ?