Home 
Search 
Today's Posts 
#1




how to locate a point on excel graph?
just in graph ,and o not use trend analysis, or that stuff

#2




how to locate a point on excel graph?
You mean, how do you place a point on an Excel chart, or how do you
determine the location of such a point?  Jon  Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ logetic wrote: just in graph ,and o not use trend analysis, or that stuff 
#3




how to locate a point on excel graph?
Jon,
Not intending to threadjack, but are both of those possible? I was recently asked by a colleage if it was possible to randomly pick a point on a chart and have excel then spit out the coordinates. Expanding on this, would it be possible to do something similar using a scanned image (say, a graph from a textbook)?  Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jon Peltier" wrote: You mean, how do you place a point on an Excel chart, or how do you determine the location of such a point?  Jon  Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ logetic wrote: just in graph ,and o not use trend analysis, or that stuff 
#4




how to locate a point on excel graph?
Luke 
Number 1 is easy: Chart Events in Microsoft Excel http://www.computorcompanion.com/LPMArticle.asp?ID=221 Number 2  I've seen descriptions of programs that digitize scanned images, but I've never used any. One that I've seen several times is called Grab It (http://www.datatrendsoftware.com/).  Jon  Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Luke M wrote: Jon, Not intending to threadjack, but are both of those possible? I was recently asked by a colleage if it was possible to randomly pick a point on a chart and have excel then spit out the coordinates. Expanding on this, would it be possible to do something similar using a scanned image (say, a graph from a textbook)? 
#5




how to locate a point on excel graph?
Hi
here http://www.excelabo.net/exemples/sgfccoordonneesgraph you can dowload a file which answers your demand. I am afraid it is in french ! if you do not understand french here is the translation of the key instructions: paste in the frame (actually this is an empty graph) a picture of a graph you want to analyze (i.e. one scanned from a document). Resize the picture so that it is just slightly larger than the frame. Do not zoom Click on the mouse move button pass the mouse over the graph. The coordinates are displayed in the blue zone ("points sous la souris") Now define the coordinates of the axis origins:  click on mouse move, place the mouse on the (0, 0) point on the graph. report the values displayed in the blue zone in the green one (below "origine des axes"). If the x (or y) axis does not start at 0, write the actual value under X0 and Y0 Now collect the values for the maximal value of each axis: place the mouse over the maximal value of the axis, note the coordinate in the blue zone, report it under "maximas des axes" and indicate the corresponding real values under xmax and ymax . Now, to collect values displayed in the graph Click on mousemove click on each point of the graph you want to collect the coordinates of the point are displayed in the purple zone, "translated" using the coordinates of the axis. If you are using a logaritmic scale for the axes you will have to adapt the formulas used to calculate the values. each collected value should be automatically copied under the yellow zone but there is a problem with this function if I remember well in 2007 and I had no time to look at this more carefully. The class module was written by Serge Garneau. I use this tool quite often, for instance to redraw some graph with a cleaner presentation. Misange Luke M a Ã©crit : Jon, Not intending to threadjack, but are both of those possible? I was recently asked by a colleage if it was possible to randomly pick a point on a chart and have excel then spit out the coordinates. Expanding on this, would it be possible to do something similar using a scanned image (say, a graph from a textbook)? 
#6




how to locate a point on excel graph?
Em quartafeira, 30 de setembro de 2009 04:53:41 UTC3, Misange escreveu:
Hi here http://www.excelabo.net/exemples/sgfccoordonneesgraph you can dowload a file which answers your demand. I am afraid it is in french ! if you do not understand french here is the translation of the key instructions: paste in the frame (actually this is an empty graph) a picture of a graph you want to analyze (i.e. one scanned from a document). Resize the picture so that it is just slightly larger than the frame. Do not zoom Click on the mouse move button pass the mouse over the graph. The coordinates are displayed in the blue zone ("points sous la souris") Now define the coordinates of the axis origins:  click on mouse move, place the mouse on the (0, 0) point on the graph. report the values displayed in the blue zone in the green one (below "origine des axes"). If the x (or y) axis does not start at 0, write the actual value under X0 and Y0 Now collect the values for the maximal value of each axis: place the mouse over the maximal value of the axis, note the coordinate in the blue zone, report it under "maximas des axes" and indicate the corresponding real values under xmax and ymax . Now, to collect values displayed in the graph Click on mousemove click on each point of the graph you want to collect the coordinates of the point are displayed in the purple zone, "translated" using the coordinates of the axis. If you are using a logaritmic scale for the axes you will have to adapt the formulas used to calculate the values. each collected value should be automatically copied under the yellow zone but there is a problem with this function if I remember well in 2007 and I had no time to look at this more carefully. The class module was written by Serge Garneau. I use this tool quite often, for instance to redraw some graph with a cleaner presentation. Misange Luke M a Ã©crit : Jon, Not intending to threadjack, but are both of those possible? I was recently asked by a colleage if it was possible to randomly pick a point on a chart and have excel then spit out the coordinates. Expanding on this, would it be possible to do something similar using a scanned image (say, a graph from a textbook)? Hi, Misange, i need this macro about http://www.excelabo.net/exemples/sgfccoordonneesgraph to collect individual point to a list of points (not entire serie) but website is not access. please put here the code or sample file thanks! 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
How do i locate the point of intersection of two lines graphs  Charts and Charting in Excel  
Excel (2007) won't do a particular XY (Point) graph for me..  Charts and Charting in Excel  
how do i export a graph from excel to power point?  Charts and Charting in Excel  
How do I point out a specific date on a line graph in Excel?  Charts and Charting in Excel  
Excel should let you graph every nth data point in a column  Charts and Charting in Excel 