#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default start at not zer

how would i go about creating a scatter graph without including 0-60 in the y
axis?
i have a column of values which i have used to make a scatter graph, the
lowest being 76ish and the highest being 123ish, so there is no need for the
space for 0 - 70, so how would i not include this, or use that little symbol
which means that the graph units don't start at zero (the little zigzag on
the line)
any help would be appreciated
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default start at not zer

Format/ Axis/ Scale
and set the minimum to your desired value.

.... or for a broken axis, try
http://peltiertech.com/Excel/Charts/BrokenYAxis.html
--
David Biddulph

"joseph1102" wrote in message
...
how would i go about creating a scatter graph without including 0-60 in
the y
axis?
i have a column of values which i have used to make a scatter graph, the
lowest being 76ish and the highest being 123ish, so there is no need for
the
space for 0 - 70, so how would i not include this, or use that little
symbol
which means that the graph units don't start at zero (the little zigzag on
the line)
any help would be appreciated



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
start:1 and start:2 - how did i get 2 copies? LuvHaleiwa Excel Discussion (Misc queries) 1 December 21st 07 09:14 PM
Where to start? Glenda J. New Users to Excel 3 April 24th 07 09:10 AM
OT :Start your own online business today !start making dollars [email protected] Excel Discussion (Misc queries) 0 May 6th 06 09:29 PM
Start spreadsheet with WinXP start Gordon Gradwell Excel Worksheet Functions 1 July 13th 05 11:35 AM
Start up Chad Excel Discussion (Misc queries) 3 May 5th 05 10:02 PM


All times are GMT +1. The time now is 04:49 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"