Discussion Locked
0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Okay, picture this: Let's say that you have a group of graphics in any format, and you want to map their location with x and y coordinates or any other method, pretty much the same way you would map a hotspot on a web page's graphic. Now lets say you want to keep track of those locations or coordinates on an Excel spreadsheet. Now to make it even better, lets say you want those coordinates to dynamically update as you move those graphics around within a defined area or on top of another graphic, therefore changing the coordinates. Is this possible? Is there a trick I can use for this? Would I need to create an external script or application for this purpose? And if so, how would it more or less work?
4 replies
by aldanatech
Because this is not a easy one to pull, I decided to raise the TechPoint value a bit.
by aldanatech
Because this is not an easy one to pull, I decided to raise the TechPoint value a bit.
by bristar
I just answered this in an identical post you put up.
VBA can't get you this information, but XLM can. Try the following (
assume you have only one series): dXVal = ExecuteExcel4Macro("GET.CHART.ITEM(1,2,""S1P" & i & """)")
dYVal = ExecuteExcel4Macro("GET.CHART.ITEM(2,2,""S1P" & i & """)")
dYVal1 = ActiveChart.ChartArea.Height - dYVal
dXVal and dYVal1 should get you what you need - or at least pretty close. You can put this in a For loop with changing i (Dim i As Integer) to get the coordinates for all the points in the series.
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending
Discussion Locked
What Makes a Business Website Effective in 2026
2 helpful
10 replies
1 helpful
3 replies
Question
Windows and macOS computers becoming slow or unstable after updates - what should I check first
0 helpful
1 reply
Question Unanswered
Best Way to Make Long WordPress Location Guides Mobile Friendly
0 helpful
0 replies
Discussion
Optimizing WordPress widgets and DOM size
0 helpful
3 replies