#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default scale on scatter

hi

i have tried a few ways to alter the scale on the x axis of a scatter
graph but so far not found a way to do it as i would like.

my data point are at: 2 4 8 16 32 64 etc
i want the axis to start at 2 but have major markers at 8 16 24 32 etc
(8 seperations)

the problem is when i set the min to 2 i cant get the divisions to line
up with 8 16 instead they are 10 18 etc

if i set the axis to min 0 and set the axis cross bit to 2 i get a
horrid bit to the left of the axis which i do not want.

does anyone know how i can set the axis to a point but not have it
going to the left of the axis.

many thanks


ps while i am posting i will ask another quick question. does
anyone know how to get thesqiggle on the axis by 0 to show that there
is a break in the scale ie 0 sqiggle 42 44 46 etc? thanks
again

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
Default scale on scatter

You cannot have ticks at 2, 8, 16, 24 since the separation for the first
pair is 6 but 8 for the other pairs. Why not start at 0?
Format the axis. On the Scale tab specify Min and Man values and set Major
Units to 4.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Tom Jacobs" wrote in message
oups.com...
hi

i have tried a few ways to alter the scale on the x axis of a scatter
graph but so far not found a way to do it as i would like.

my data point are at: 2 4 8 16 32 64 etc
i want the axis to start at 2 but have major markers at 8 16 24 32 etc
(8 seperations)

the problem is when i set the min to 2 i cant get the divisions to line
up with 8 16 instead they are 10 18 etc

if i set the axis to min 0 and set the axis cross bit to 2 i get a
horrid bit to the left of the axis which i do not want.

does anyone know how i can set the axis to a point but not have it
going to the left of the axis.

many thanks


ps while i am posting i will ask another quick question. does
anyone know how to get thesqiggle on the axis by 0 to show that there
is a break in the scale ie 0 sqiggle 42 44 46 etc? thanks
again



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
How to make Primary axis and Secondary X-axis have the same scale AdamCPTD Excel Discussion (Misc queries) 0 July 14th 06 02:14 PM
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
Changing the scale major unit in a graph Ant Excel Discussion (Misc queries) 2 February 6th 06 01:42 PM
Locking the scale ratio of X-Y axis in XY scatter charts DK-Mech Charts and Charting in Excel 4 January 28th 05 09:13 AM


All times are GMT +1. The time now is 09:05 AM.

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"