Need help creating a graph that can automatically keep the x & y axis in the same scale

So i am trying to plot geographical data, and as such i need the x and y axis to be of the exact same scale. Furthermore, the area of the graph may change with each use, as i plot different sized areas of land. I managed to find this code (below) which looks like it should work, however im not really sure how to use it in this application. When i assign it to a graph either nothing happens, or i get an error saying that the .PlotArea has not been set. I'm no good at VBA haha, so just hoping someone could explain how i should integrate this into my graph.

Cheers,
Chris

Please Login or Register  to view this content.

From that chunk of code, seems like you only need:

Please Login or Register  to view this content.

Amend and add to your existing code that creates the chart?

Thanks for the reply. This is part of my problem- the chart itself is not part of a macro, or created by one. It's a fixed object on the sheet if tat makes sense. I just need it to automatically scale as i input data (as standard graphs usually do) but keep the x/y axis ratio even at 1:1. However, i have no idea how to attribute VBA code to the graph to achieve this..

Please post a sample workbook (with all sensitive data removed), showing where is the data being input, and with that chart.

Also, by what you described, do you also mean that the chart's source data should dynamically change as well?

Well if a dynamic table is what i think it is, then i don't think it's necessary as i have found a way around it (not a very nice way but it works). On that sheet, you can see that the graph picks up two sets of data using x1,y1 points and x2,y2 points


Attachment 282988