Tushar Mehta (http://tushar-mehta.com) has a utility called Chart Hover
Label which provides custom pseudo chart tips.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Fermon" wrote in message
...
Jon,

After responding to your post, I thought I'd look again for "screentips"
or
"screen tips" and, what do you know, I found a reference to an article
written by you on the very subject I need. The article is he
<http://www.computorcompanion.com/LPMArticle.asp?ID=221 in case someone
else
does a search on the topic.

I will look into this, using the MouseMove event to see if I get anywhere.
Any updated info you may have or books you recommend are appreciated.

Thanks so much again,

Fermon

"Fermon" wrote:

Jon,

Thanks for your help on this. Yes you did warn me about the data
arrangement, and you were right about the labeling. I need to have
separate
labels for each point, but I need them to appear in the ScreenTip, when
the
user hovers over a specific point.

The charts quickly become unreadable when there are too many labels and
the
screentip allows me to show the extra specific data I need for the point
without cluttering the entire graph. Not quite in the format I'd like but
the
information is there.

I downloaded Rob Bovey's chart labeler and, in fact, I had experimented
with
labels myself when I first started to create this spreadsheet. The
problem is
that labels do not work well for me. Now, if there is a similar utility
that
allows me to change the ScreenTip, I would really like to get that one.
The
problem, though is that I am still haaving to create individual series
for
each data point with the limitations that the approach imposes.

Perhaps I can use mapping techniques to follow the user's mouse over the
chart and provide extra info when appropriate but that sounds like a lot
more
work than creating separate series for each row. Also I am fortunate
enough
that the 255 (or less) Excel series limitation is not a major roadblock
for
this particular application.

The technique you gave me for changing the Chart type and then deleting
the
series works for me. I'll incorporate that into my application.

Thanks again,

Fermon

"Jon Peltier" wrote:

Well, I did say "If the data is properly arranged...." <g

Why do you need separate one-point series? If you just need separate
labels
on each point, use one of these utilities:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

Back to your issue, if the data is not plottable (i.e., it's blank),
you
cannot access certain properties and methods of a series, if it is a
marker-type series (Line or XY). However, you can convert it to a
different
type first:

With
ActiveChart.SeriesCollection(ActiveChart.SeriesCol lection.Count)
.ChartType = xlColumnClustered
.Delete
End With

When the series is re-added, it reverts to the main chart type, XY.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______