Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
drawing bell graphs side-by-side ChartsNewbie Charts and Charting in Excel 7 May 16th 07 07:55 PM
Problem in Drawing Lines (AutoShapes) Jac Excel Discussion (Misc queries) 0 October 8th 06 08:45 AM
Problem in Drawing Lines (AutoShapes) Jac Excel Discussion (Misc queries) 0 October 8th 06 08:37 AM
problem with drawing vertical line on chart [email protected] Charts and Charting in Excel 2 May 24th 06 04:55 AM
Problem drawing lines on charts Susan Lambert Charts and Charting in Excel 7 December 13th 04 08:29 AM


All times are GMT +1. The time now is 04:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"