Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
start:1 and start:2 - how did i get 2 copies? | Excel Discussion (Misc queries) | |||
Where to start? | New Users to Excel | |||
OT :Start your own online business today !start making dollars | Excel Discussion (Misc queries) | |||
Start spreadsheet with WinXP start | Excel Worksheet Functions | |||
Start up | Excel Discussion (Misc queries) |