Excel charts not plotting properly: problem solved

[Oz Springs]

Only some of the rows had labels (others removed to make Illustrator
graph handle the data better) and Excel would only take data from the
labelled rows. Which also explains why the resultant graphs were so
smoothed out.

Would prefer it if Excel would take the first row of data rather than
the row of headings as to whether it should accept data or not. Or at
least ask if the user wanted to omit the unlabelled rows.

Kind regards



Oz

 

[JE McGimpsey]

Only some of the rows had labels (others removed to make Illustrator
graph handle the data better) and Excel would only take data from the
labelled rows. Which also explains why the resultant graphs were so
smoothed out.

Would prefer it if Excel would take the first row of data rather than
the row of headings as to whether it should accept data or not. Or at
least ask if the user wanted to omit the unlabelled rows.

Since line charts plot data by position, not label, I don't understand
this, but if you've got it sorted out, that's good.