ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problem with drawing graphs (https://www.excelbanter.com/excel-programming/281110-problem-drawing-graphs.html)

vidhya

Problem with drawing graphs
 
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.

Chrissy[_6_]

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.





All times are GMT +1. The time now is 10:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com