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. |
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