When plotting an XY scatter graph with 2 series and both series containing the identical formulae in the cells; one of the series will plot fine while the other will pick up the row numbers rather than the values. Highlighting a data point from{ series 1 Point “344.82”(344.82,2576.93)} and from {series 2 Point”493.93”(98,2657.87)} in the series 2 98 is row number rather than the value 493.93. Both of the series values are from identical spreadsheets where one is the proposed values and the other is actual values using the same trig formulas.
I have checked the X&Y ranges many times. Any ideas? Using Excel 2007.
I have checked the X&Y ranges many times. Any ideas? Using Excel 2007.