matching the scales on a chart

[gareth93]

hi,
i'm using a simple chart to display a crane mechanism. i need to match the physical scales of both the x & y axes, so the display is to scale. Eg, the distance between values 0 & 1 will be the same on both axes. the only way i can do it is to manually drag the chart corners until it looked about right.

cheers if neone can help

Gareth

[Bryan Hessey]

hi,
i'm using a simple chart to display a crane mechanism. i need to match the physical scales of both the x & y axes, so the display is to scale. Eg, the distance between values 0 & 1 will be the same on both axes. the only way i can do it is to manually drag the chart corners until it looked about right.

cheers if neone can help

Gareth

My (very) limited knowledge of charts suggests that the display area you are trying to control is affected by the size (height & width) of the chart object, adjusted by any Legend and/or Axis labels to give the Plot area, adjusted by any Data Labels etc to give the area used to display data (the ridlines area). I doubt that you can set the figures for sizing elements of this area, however you can set the Upper and Lower limits to fix the Y scale, and the X scale is dependant on your selection.

To aid in 'sizing' you can draw a Shape (rectangle) and set the width and height equal, set the Transparency to 100% and drag this in front of your chart to help in checking what is 'square'.

Hope this helps
---

[MrShorty]

I've played around with this once. How familiar are you with VBA? You can, to some degree, set the length of each axis by changing the width and height properties of the plotarea object. The width and height properties of the axis objects are read-only, so you can't directly set them.