DataLabels on XY Scatter Chart

[Johler]

Does anyone out there have any experience with the XY Scatter Chart. Specifically labeling points. I have a recordset, which returns a set of data points and a description for each point, from a SQL database. The dataset is an X coordinate, a Y coordinate and a description of the point. I am able to turn on the label, but the scatter only shows the value of the coordinates, not the description. I want to be able to set the datapoint to a field in my recordset called description. the x,y coordinates are of no use to the viewer of the Chart. In Excel it is fairly simple to assign a data point to a text field through the VBA. I think it is probably possible, but don't know the syntax in the OWC to set each point to a recordset field. Any help would be greatly appreciated.

 

[Alvin Bruney [MVP]]

plotting takes co-ordinates only. to display text on screen you will need to
look into events. basically, you will handle each point being plotted on
screen thru the afterrender event and you will draw your appropriate text at
the specified co-ordinates. please be sure to read about licensing as well
as it directly impacts what you are doing. you will find more information on
MSDN

 

[Johler]

Thanks for the help! I hadn't paid very close attention to the order in which I had charted the data and added points in the VBA. I am using ASP for the charts, and am saving the chart to a GIF in the ASP. I don't know if I will be able to use the afterrender event. I have however found the chDimseriesNames dimension and have been able to make a work around by splitting the Dataset into several series. As for the liscensing issue, I don't understand how licensing will impact my work. My company has licensed several thousand copies of Office, but staying MS compliant is mission critical for us. If licensing becomes an issue, I will turn it over to my IS department. Thanks again for the help, it has helped me get over my charting issue

----- Alvin Bruney [MVP] wrote: ----

plotting takes co-ordinates only. to display text on screen you will need to
look into events. basically, you will handle each point being plotted on
screen thru the afterrender event and you will draw your appropriate text at
the specified co-ordinates. please be sure to read about licensing as well
as it directly impacts what you are doing. you will find more information on
MSD