Excel charts not plotting properly: problem solved

O

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
 
J

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.
Click to expand...
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.
Click to expand...

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.
 
Top