Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / November 2003

Tip: Looking for answers? Try searching our database.

Limitation on point labels in x-y plot.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
James Silverton - 27 Nov 2003 16:04 GMT
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"
<andy@digitab.demon.co.uk>  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,

Signature

James V. Silverton
Potomac, Maryland, USA

James Silverton - 27 Nov 2003 16:14 GMT
> Some time ago, Ron Peltier, in particular, gave me a lot of assistance on
> attaching labels to points. However, the method that best suits
[quoted text clipped - 10 lines]
> 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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.