Excel graphing and axis -
i have scatterplot values range 2 -2. catch 1 "zero-point". in other words minimum positive value 1.01 , minimum negative value -1.01. how can edit axis of graph 0 replaced 1.
if have version of excel later 2007 i'd suggest splitting positives , negatives separate series , plotting 1 on secondary axis (not know whether or not work!), 2007 have not been able place 1 vertical axis above horizontal , below. instead best manage use 2 separate charts:
by again splitting series, careful positioning , judicious use of text box 0
.
at least way not constrained outer limits.
Comments
Post a Comment