Matching graph colours with legend error

[dunda1985]

Hi guys,

I've been having problems with trying to set certain colours to certain graphs within an excel chart and then matching that colour to the font of a legend. The run-time error 1004 appears when there is no graph to select.

See the code below for reference. So for example, say I have built this sheet to automate for 5 graphs (capacity) within the one chart. Say I only have 3 actual graphs, therefore the error will occur on the line of code:

Please Login or Register  to view this content.

because there is no graph 4.

Now adding to the beginning of the code an error handler

Please Login or Register  to view this content.

deals with this problem, however while it skips the error in the above code, it does not skip the body of code next to it. In other words, because prior to the error, graph 3 was selected, it will continue with the 'workable' codes:

Please Login or Register  to view this content.

Thus working its way all the way to the last line of code. So in this particular example with 3 available graphs out of a capacity of 5, the colour index of the third (and last available) graph will be

Please Login or Register  to view this content.

and not

Please Login or Register  to view this content.

I hope I'm making sense. I would really appreciate it if anyone could come up with a solution or workaround please? Many many thanks in advance.

See below for the 'full code':

Please Login or Register  to view this content.

[davegugg]

Instead of coding the coloring separately, loop through each series:

Please Login or Register  to view this content.

[dunda1985]

Hi Davegugg,

I've already got the code working in a looped function. I broke it out to describe the problem. Thanks for your help, however it's still not resolving my problem. The problem is the last avaialble graph is still selected, and the next part of the code that runs without the error will continue to run with the next part of the code:

Please Login or Register  to view this content.

In other words, say I only have 6 graphs out of a capacity for 30 graphs (30 preassigned colours). The 6th graph is still selected with the code:

Please Login or Register  to view this content.

and due to handling error,

Please Login or Register  to view this content.

will still be selected all the way to

Please Login or Register  to view this content.

The problem then becomes that the last entry in the legend is not the same colour as its corresponding graph.

Many thanks in advance for your help.

[davegugg]

I don't understand. You say you have a variable number of graphs, but your code above all only works on one graph, ChartA. Are you talking about multiple charts, or multiple data series? Perhaps you could post a small sample workbook?

[romperstomper]

Don't select:

Please Login or Register  to view this content.

[dunda1985]

D'oh! Thank you for the simply obvious solution romperstomper!

Sorry davegugg, each data series on a chart is technically a 'graph'. Sorry for the confusion and many thanks for your help.

Also, how do I mark this thread as solved please?

[romperstomper]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[dunda1985]

done, thanks