Hi friends . If possible help get a code VBA Write that calculates both the slope of the line and the distance between two lines on the Excel chart . According to the photo I send . Thank you very much friends
Hi friends . If possible help get a code VBA Write that calculates both the slope of the line and the distance between two lines on the Excel chart . According to the photo I send . Thank you very much friends
Administrative note
Welcome to the forum
in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?
Please take a moment to read it and attach a sheet accordingly.
Thanks you for helping us help you
I marked the red line in the photo
Line number ten and fifteen How is the slope of these two lines calculated? Then how the distance between two lines is calculated
Last edited by HosseinDel1983; 02-13-2020 at 04:20 AM.
Thanks a lot
Hello my friend .I posted the file in the forum please help me
Last edited by AliGW; 02-13-2020 at 05:01 AM. Reason: Please don't quote unnecessarily!
Post the workbook HERE in this thread - attach it to your next post. Your other, duplicate thread has been closed.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hello my friend . My question is how to calculate the slope of the line and the distance between two lines in the Excel chart
Last edited by AliGW; 02-13-2020 at 05:01 AM. Reason: Please don't quote unnecessarily!
I asked you for the workbook. Is it the one you attached to post #4?
Administrative Note:
We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - it has been only an hour since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.
Administrative Note:
Please don't quote entire posts unnecessarily. They clutter threads and make them hard to read.
Use the "Quick reply" instead
Thanks
Perhaps there's some language problem here. I'm a VBA novice but I don't think you will get a solution from anyone until you provide more information:
1. The lines' co-ordinate data, not just an image. Any two points on the line (x1,y1) and (x2,y2) will define it.
2. Clarify what you mean by "...the distance between the two lines". This is not a constant. It depends on which two points you choose as its start and end.
3. And "...to calculate the slope of line number ten and fifteen" do you mean you want the angle between these two? Or do you want two angles, one for each line? In which case between which axis, x or y? Measured in which direction, clockwise or anti clockwise?
With that data, I think a VBA expert could write a VBA sub using the appropriate trigonometry!
Terry, East Grinstead, UK
Excel 365, Win 10 Pro, i7 PC, 4.0 GHz
I sent you an example of an Excel file containing the chart
Last edited by AliGW; 02-13-2020 at 05:02 AM. Reason: Please don't quote unnecessarily!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks