XY Scatter label and colouring problem

[twinkle100]

Hi, here is my first post! I hope someone can get me back on the right road with this please. Any help gratefully received.

The code should be helping label up a XY scatter chart, and colour points and text for similar items on the chart.

The routine gets into trouble where I start to set out to loop through the label process followed by the colouring stuff. (I took the label routine from the MS website).

The code snags up with a runtime error 1004 Method 'Range' of Object'_Global' failed on the line below

ReDim mylabelarray((Range(xVals).Cells.Count + 1), 4)

Here is the code. To get it working you need some data in column H and column L starting at row 40. Cell A1 should contain the row number of the end of the data. This is because the length of the data may well be different each time I want to use the chart and so by changing the ref in A1 I can adjust the chart dimensions....

Please Login or Register  to view this content.

[Andy Pope]

You can only redim the outer array element, not the inner ones

[twinkle100]

Hi Andy, thanks for the swift reply.

Can you elaborate on that a little please? How do I split up that code and still achieve the correct parameters for the two elements?

Many thanks again

[Andy Pope]

first you need to explain what the code should be doing?
Post example file