Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / September 2006

Tip: Looking for answers? Try searching our database.

scale on scatter

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tom  Jacobs - 12 Sep 2006 14:55 GMT
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
Bernard Liengme - 12 Sep 2006 17:55 GMT
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
Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> hi
>
[quoted text clipped - 20 lines]
> is a break in the scale   ie    0  sqiggle  42  44  46 etc?  thanks
> again
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.