I'm making thrust curves in Excel using scatter charts. I've got tables that
have thrust vs speed for each gear. When I limit the data series range to
cells with data in them, everything works and each data series has the
correct registry vs the x (speed) axis. But now I'm creating a generic
spreadsheet where any user could cut and paste data from chassis dynos, so
I've changed the tables that get filled out to be longer. I use if(location
< 0, value, "") statements to keep unneeded cells from being filled with
zeros, and now all the series get placed on the graphs based on data point
number, not the X axis value. This really is a royal PITA, as in effect it's
destroying the scatter plot. Any ideas here?