Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
DK-Mech
 
Posts: n/a
Default Locking the scale ratio of X-Y axis in XY scatter charts

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?
  #2   Report Post  
John Mansfield
 
Posts: n/a
Default

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.

----
Regards,
John Mansfield
http://www.pdbook.com


"DK-Mech" wrote:

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?

  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

You need to use VBA to do this, as described in this article:

http://peltiertech.com/Excel/Charts/SquareGrid.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

DK-Mech wrote:

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?

  #4   Report Post  
DK-Mech
 
Posts: n/a
Default

I was just using pixels as an example. I suppose it wasn't a very good one.
Thanks anyway.

"John Mansfield" wrote:

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.

----
Regards,
John Mansfield
http://www.pdbook.com


"DK-Mech" wrote:

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?

  #5   Report Post  
DK-Mech
 
Posts: n/a
Default

Thanks, this helps.

"Jon Peltier" wrote:

You need to use VBA to do this, as described in this article:

http://peltiertech.com/Excel/Charts/SquareGrid.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

DK-Mech wrote:

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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
combing two bar charts to share one axis Penny Charts and Charting in Excel 3 January 27th 05 06:15 PM
"X" Axis in Excel Charts LPS Charts and Charting in Excel 3 January 21st 05 05:49 PM
change axis info on radar charts alfred Charts and Charting in Excel 1 January 11th 05 05:36 AM
secondary axis scale Kent Smith Charts and Charting in Excel 3 January 4th 05 08:37 PM
the dates to label the x axis on the scatter chart won't print waterlady Charts and Charting in Excel 0 November 29th 04 07:44 PM


All times are GMT +1. The time now is 11:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"