Hi,
I have a graph which pulls its data from an x and y column each 200 cells long. However sometimes not all 200 rows are used but the graph is still looking at all 200 rows, so to stop the scale being messed up I put #N/A in these cells and the graph ignores them. However taking the next step, when I put the #N/A in an IF statement so the the cells equal #N/A when not required the graph goes funny and starts ignoring the x values and plots integer values instead on the x axis! How can I stop the graph's scale being messed up like this?
I have checked cell formatting and both times the type is general.
Bookmarks