Hi
I need to generate monthly charts. There are 14 chart in my sheet. I need to write a macro so that all those graph are automatically updated with new month's data. For that the macro should:
Select the graph sequentially. (one after other)
Select the data
Add one more row(data of month)
update the graph
I tried different ways but
anyone any suggestion
Bookmarks