Hello again!
Ok, the title was not long enough to explain. The real goal is to be able to take measurements from a chart that is already made in excel ( line/series chart ) . Usually, with other software I've used, this is done by drawing a line. Then, that line will have the option to show it's length, somewhere off to the side. (*and if that's all we can do here, then that would be a good goal too).
I know that we can click on the line and then look at the size of it that way. But it is pretty tedious in the long run, with large amounts of data to go over.
So, the idea I had was to create (or get help in creating...) a VBA code that could maybe auto-detect a line that is drawn, and then take those coordinates and plot them in the appropriate cells, off to the side of the original data. So, if it's a chart that uses dates, it would find the beginning and ending coordinates of that hand drawn line, (x,y), and plot it in the cells at those dates (y coordinates)... of to the right of the original data that is the main chart.
Now, in case this is not enough info, or not possible, I'll include info on what the problem I'm facing is...
any drawn lines on a chart do not stay attached to that chart....when the chart moves, the line stays put rather than moving. (btw I created a scroll chart, so it scrolls to the right and left. (and) as it scrolls, the drawn line just stays there, while the data moves to the left or right. So, I'd like to be able to mark something on the chart and be able to go back later and look at it, but alas, it's very temporary.
So in review there are really a couple issues here:
1) is there a handy vba for plotting the size of manually drawn line(drawn onto a chart), off to the side of that line, in a text, so I can read it easily w/out clicking on the line/format....etc.
2) is there a way to get the line to stay attached to the data, and move with that data? .....
3) in trying to solve 2, I thought that it might be possible to have a vba that can tell the coordinates of the line, and plot those in chosen cell(s) off to the right of the original chart data...thus making the line a bit more permanent.
So ?????????????? any ideas here? *Or maybe you have your own brainstorm on how to solve these problems some other way? Even if you choose not to actually write out the code, maybe you can tell me what is possible, so that I may choose to learn it, or hire someone ??
Thank you sincerely for your time, it really means a lot !
Bookmarks