Locking the scale ratio of X-Y axis in XY scatter charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When presenting results via scatter charts it is often preferred to keep the
scales identical on both axis (i.e. a unit on each axis is equal to the same
number of pixels on screen). Is it possible to do that in Excel?
 
DK,

Since the resolutions of PCs and printers vary, it would probably be more
advantageous to create a proportional relationship between the X and Y scales
for the two charts. For example, a single unit on the X axis of chart 1
might be equal to 2 units on the X axis on chart 2. 3 units on the Y axis of
chart 1 might equal 6 units on the Y axis of chart 2. You can easily set up
these types of proportional relationships with algebra.

If you choose a proportional setup similar to this your viewers can quickly
tell what the relationships are. They may not be able to do so if you're
trying to measure the two charts against pixels on a screen.
 
I was just using pixels as an example. I suppose it wasn't a very good one.
Thanks anyway.
 
Back
Top