ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   start at not zer (https://www.excelbanter.com/charts-charting-excel/189110-start-not-zer.html)

joseph1102

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

David Biddulph[_2_]

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





All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com