Limitation on point labels in x-y plot.

[James Silverton]

Some time ago, Ron Peltier, in particular, gave me a lot of assistance on
attaching labels to points. However, the method that best suits
me for XY ("scatter) charts came from a suggestion by "Andy Pope"
<[email protected]> who mentioned Rob Bovey's XY Chart Labeler which
is free and down-loadable from:

http://www.appspro.com/utilities/utilities.asp

Today, trying to label a chart with rather a lot of points, I came across a
limitation of Rob's very useful labeller. It seems that the last point index
it can handle is 707 in my chart when I wanted 751. I wonder if anyone can
tell me how to increase this number? I suppose I could try to read thro' the
code but I never was very familiar with Visual Basic and I am out of
practice anyway.

TIA,

 

[James Silverton]

Some time ago, Ron Peltier, in particular, gave me a lot of assistance on
attaching labels to points. However, the method that best suits
me for XY ("scatter) charts came from a suggestion by "Andy Pope"
<[email protected]> who mentioned Rob Bovey's XY Chart Labeler which
is free and down-loadable from:

http://www.appspro.com/utilities/utilities.asp

Today, trying to label a chart with rather a lot of points, I came across a
limitation of Rob's very useful labeller. It seems that the last point index
it can handle is 707 in my chart when I wanted 751. I wonder if anyone can
tell me how to increase this number? I suppose I could try to read thro' the
code but I never was very familiar with Visual Basic and I am out of
practice anyway.

I did not mean to send this post until I had done some further checking but
I hit the wrong key. The limitation I mentioned does not seem to be real. It
seems that what is displayed in the Chart Labeler is the number of the point
not its x-value which Excel calls the "point index". Sorry if anyone has
already started to consider the problem. I'll just have to remember the
nomenclature (g).

Happy Thanksgiving to everyone!

Jim.