Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drawing bell graphs side-by-side | Charts and Charting in Excel | |||
Problem in Drawing Lines (AutoShapes) | Excel Discussion (Misc queries) | |||
Problem in Drawing Lines (AutoShapes) | Excel Discussion (Misc queries) | |||
problem with drawing vertical line on chart | Charts and Charting in Excel | |||
Problem drawing lines on charts | Charts and Charting in Excel |