Label coordinates in Scatter plot

[ajaysomasi]

Hi, I'm trying to plot a scatter chart and need to know how to label each coordinate.. I have the following problem.

I have different regions, Middle East, Asia, Europe.. I have a number of cities in each category (upto 20) and the number of cities keep changing based on input..

I have a requirement to plot cities by region.. Eg. ME cities I have triangle coordinates, Asia rectangular and Europe Circle to differentiate cities of each region.. I now need to label cities as well...

While plotting cities by region, I have the series name as Middle East and pulled all X,Y coordinates of cities lying in Middle East. But now, I am forced to use text box to label each city..

Is there any way I can differentiate cities by region while at the same time, name the cities too...

 

[NdNoviceHlp]

I'm guessing your referring to data labels. Here's some code to alter data labels. Data labels are attached to points. HTH. Dave

ActiveChart.SeriesCollection(1).Points(1).DataLabel.Text = "bart"
With Sheets("Sheet1").ChartObjects(1).Chart.SeriesCollection(1).DataLabels
.NumberFormat = "0.0"
.VerticalAlignment = xlCenter
.Position = xlLabelPositionBelow
.Orientation = xlHorizontal
.AutoScaleFont = False
.Font.Size = 11
.Font.Bold = True
.Font.ColorIndex = 3
End With