Limitation on point labels in x-y plot.

  • Thread starter Thread starter James Silverton
  • Start date Start date
J

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 said:
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.
Click to expand...

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.
 
Back
Top