Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 7th 07, 11:31 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 414
Default Axis scale on X-Y scatter graph

Is it possible to link the scales for the X and Y axis so that the scale can
increase/decrease automatically, but both X and Y always cover the same
range. I am plotting data which is just easier to read if 0,0 remains in the
centre of the graph - I could fix the axis scale, but I want to leave as
'auto' due to the changing data.

Thanks,

Andy

  #2   Report Post  
Old February 7th 07, 11:58 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 560
Default Axis scale on X-Y scatter graph

On Wed, 7 Feb 2007, in microsoft.public.excel.charting,
Andy said:
Is it possible to link the scales for the X and Y axis so that the scale can
increase/decrease automatically, but both X and Y always cover the same
range. I am plotting data which is just easier to read if 0,0 remains in the
centre of the graph - I could fix the axis scale, but I want to leave as
'auto' due to the changing data.


I would suggest creating an invisible data range consisting of four
scatter points whose x values are plus and minus the MAX() values of the
real x values, and whose y values are +/- the MAX() of the displayed y
values.

x y
MAX(x-range) MAX(y-range)
-MAX(x-range) MAX(y-range)
MAX(x-range) -MAX(y-range)
-MAX(x-range) -MAX(y-range)

This invisible rectangle should, if I'm right, keep your automatic
ranges centred on the screen.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.
  #3   Report Post  
Old February 8th 07, 12:50 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,071
Default Axis scale on X-Y scatter graph

Del has the right idea but you need to use a more complex approach. Instead
of just MAX(x-range) use MAX(MAX(x-range),ABS(MIN(x-range))) This will cater
to the possibility that the -ve values have a larger absolute magnitude than
the positive values.

This *should* give you (0,0) in the center but one cannot be sure since XL's
algorithm for calculating the axis scaling is not documented (at least the
last time I checked it was documented for XL5 and not for any later version).
--

Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"Andy" wrote:

Is it possible to link the scales for the X and Y axis so that the scale can
increase/decrease automatically, but both X and Y always cover the same
range. I am plotting data which is just easier to read if 0,0 remains in the
centre of the graph - I could fix the axis scale, but I want to leave as
'auto' due to the changing data.

Thanks,

Andy



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
Changing Y Axis Scale with percentages (Line Graph) p-diddy Charts and Charting in Excel 2 December 21st 06 02:25 PM
How do I split the axis scale on a line graph Fish_Biologist Excel Discussion (Misc queries) 2 May 24th 06 05:30 AM
Scale on X & Y Axis of the scatter chart chanyke Charts and Charting in Excel 3 April 28th 06 02:01 AM
X axis scale on an XY scatter plot Tim Charts and Charting in Excel 1 March 21st 06 12:51 PM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM


All times are GMT +1. The time now is 06:37 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017