I tried to post this to microsoft.public.excel.programming yesterday via
Google, got a copy sent to me, but it's nowhere to be found on that
newsgroup. My normal ISP doesn't carry the Microsoft groups. Since
this is related to Access, I'm hoping I can repost this here and get a
response.
HI folks,
I'm an Access developer and my current app manipulates MS Graph
generated charts in Access. To determine code needed, I record Excel
macros, examine the resultant VBA coding and adapt it for my Access
modules.
What I'm looking to get is what one sees in controltip text when you
mouse over a column in, for example, a column chart. For example, the
controltiptext (pop up) might show:
Series "Total Costs" Point "Labour"
Value: 128423.73
I've googled the subject and combed through the object browser and have
found partial answers, but not exactly what I'm looking for.
http://tinyurl.com/kcmwx helped me figure out the series name (after I
figured out that I had to dim sr as series), but I'm still stuck on
getting the point name. For the series' names I'm able to use:
sub sSeriesNames
Dim i As Integer
Dim sr As Series
For i = 1 To ActiveSheet.ChartObjects.Count
MsgBox ActiveSheet.ChartObjects(i).Name
For Each sr In ActiveSheet.ChartObjects(i).Chart.SeriesCollection
MsgBox sr.Name
Next
Next i
End Sub
And this will display regardless of whatever has been set in the
arguments of ApplyDataLabels.
Now, how to do similar for point name (and value, for that matter)?
TIA, any help will be much appreciated.
PS, my regular news server doesn't carry this NG. Anyone know how to
change the email address that appears from Google Groups postings?
--
Tim Marshall