I want to make several independent xy charts from data in one sheet, i.e.
col. A vs. B, col. C vs. D, etc. Question: must the values be in adjacent
columns with the abscissae in the left col.? More importantly, some of my x.y
pairs have a blank for one or the other, and the only way I can get a decent
plot is to first sort on the x values and plot that range, but that destroys
other plots I have made b/c their x values are now scrambled! I haven't
found a way around this or any help topic that addresses this. I'm running
Excel 2003 on a Solaris platform. Thanks.