Excel XY Scatter Chart 1

[KenWright]

Anyone know if I can have an XY scatter chart based on data such as the following

Desc x y
---------
aa 2 4
bb 3 5
cc 1 5
dd 3 6
ee 3 6
ff 3 7
gg 7 3
hh 6 4

have it plot those points but also let me display all the Desc tags against the appropriate records on the chart?

<I hate charts!!!>

Any help would be much appreciated, even if just to tell me I can't do it.

Cheers
Ken........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[ETID]

Use the line chart instead, select "line with markers @ each data value" from chart sub type. Then format the series to display only the markers.

 

[KenWright]

Thanks ETID, I'll try that. I should also have done a search on Google before posting :-(

There are a couple free utilities you can download to make this task easy.

Rob Bovey's Chart Labeler,

http://appspro.com

John Walkenbach's Chart Tools,

http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services

http://PeltierTech.com/Excel/Charts/

_______

Regards
Ken...............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[SkipVought]

Ken,

If Line Chart positions your x,y points using Category logic, try switching BACK to x-y scatter and running a procedure like this...

Sub AddLabels()
   r = 2
   With ActiveSheet.ChartObjects(1).Chart
      For Each pt In .SeriesCollection(1).Points
         With pt
            .HasDataLabel = True
            .DataLabel.Text = Cells(r, 1).Value
         End With
         r = r + 1
      Next
   End With
End Sub

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884