Heya,
Thanks to a tip from Andy Pope, I've made some pretty good head-way on a design-plan-mapping XY scatter plot. My question now is -
Is there a way to maintain aspect ratio through changing dimensions?
Ideally, I'd like to have the chart stay the same size, and assign dimensions accordingly on a 1 - 1 ratio from x to y. Being a plan for a fixed size of products, if it's say, 10' x 100', it should be a long narrow plan, not a x = y size chart, which portrays very distorted dimensions, IE 2' one way = 20' the other. If it's 10 x 10, or even 100 x 100, it looks great, but differences between the lengths and widths are returning wonky aspect ratios.
I'm using VBA through a command button, so if code is required, I can input it there so that it resizes on calculation. The length and width are plainly listed within my sheet.
If it's a simple format option that I can't find, well, I'm an idiot.
mew!
Bookmarks