VBA to get data by clicking on Excel chart
-
I have massive spreadsheets of data to wade through and am hoping to automate the process. I would like to make a chart of the data (x-axis is time stamp) and then have a script/macro so that I can go through plot and pick off data points by clicking on the plot. The script would read off the time-stamp and value of the closest point to my mouse click and paste it into another Sheet. I currently have to hold the mouse over the data point until the value pops up in a Tool-tip and then manually enter the value, or copy it from the original massive list. Thanks for any ideas or suggestions! Eric
-
I have massive spreadsheets of data to wade through and am hoping to automate the process. I would like to make a chart of the data (x-axis is time stamp) and then have a script/macro so that I can go through plot and pick off data points by clicking on the plot. The script would read off the time-stamp and value of the closest point to my mouse click and paste it into another Sheet. I currently have to hold the mouse over the data point until the value pops up in a Tool-tip and then manually enter the value, or copy it from the original massive list. Thanks for any ideas or suggestions! Eric
found something that might have answered my question, though I'd still like to hear your ideas... http://www.geocities.com/jonpeltier/Excel/Charts/index.html#PointInfo