View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chrissy[_6_] Chrissy[_6_] is offline
external usenet poster
 
Posts: 6
Default Problem with drawing graphs

Sub IncreaseMarkerSize()
With ActiveChart.SeriesCollection(1).Points(5)
.MarkerSize = .MarkerSize + 1
End With
End Sub


You will need to add code to allow the user to indicate which
data item you want. You will need to change what is done to that
data point too - I am increasing the marker size of the selected point.
You may want to specify which series is being used too.

Chrissy.

"vidhya" wrote in message om...
I have a database of 10000 values which i have plotted in excel
(graph)

is there any way where i can find a particular point in the graph?

say i need point x1,y1...is there a way to find it directly in the
graph rather than going and searching for it in the graph???


Thanks.