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 |
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