Using VBA to increase Graph Series Values by 1

**Maudise** · 05-22-2012, 05:26 AM

Hi All,

I'm doing the age old problem of updating graphs. I have tried several routes to solving the issue of having to have dynamic named ranges etc to automatically update a graph when new information is available.

I was wondering if anyone had done this using VBA and whether they could point me in the right direction. So far I have the following (and feel free to just tell me to re-write a better way if easier than amending my code)

Please Login or Register  to view this content.

It is currently breaking on CurrentSeriesMaxRow as a type mismatch, presumably because it is reading it as text rather than an integer (as I'm trying to get the last number from a text string and add 1 to it).

The code is already commented out to have the option to do this for each Series in the graph and eventually each graph on a specified (or all worksheets). Also I'm aware I haven't accounted for 9 becoming 10 and thus messing it up but these are side issues which I can deal with once I have the working code.

Any help would be greatly appreciated.

Thanks
Maudise