Macro has a bug when producing a graph

[dominicm]

Hello, I have got well under way with help from many of you in producing my macro to do some processing on data files. I got the code sorted to select data and produce a graph. I copied and modified this code to then select different data and produce another graph......that worked ok. I then copied and modified to produce a third graph and a bug cropped up when running the macro. It looks like the graph was created as I wanted by I got error message "The index into the specified collection is out of bounds"

At the moment after running the macro the three graphs are on top of each other, you can drag to separate which I will try and do further in the macro. The graphs don't look too meaningful but that's only because I have deleted many rows of data to keep under the maximum filesize for upload here.

Once someone kindly replies to a post I am aware that the post needs marking as resolved. I have also been giving positive feedback to the person who has helped too. Is it etiquette to also reply to the thread to say " thanks that works great" or similar?

Please find the code and excel file attached, thanks.

Please Login or Register  to view this content.

[Andy Pope]

the error is related to the text formatting of a number of characters that is greater than the text length
you had 8 character length when the text is only 5 long

Please Login or Register  to view this content.

you can add code to position chart objects to avoid the overlay problem.

It's always good to have the OP acknowledge the reply has worked either by seeing the SOLVED status or a last post comment

[dominicm]

Worked a treat thanks Andy, what can I check for to look what character length something is ready for when I do the next graph, Im not sure what the 1,8 or 1,5 relates to in my data? Cheers Dominic

[Andy Pope]

if you want it to apply to all the characters in the text then you don't need a start and length value

Please Login or Register  to view this content.

[dominicm]

Perfect, covers all bases now, thanks very much :-)