I think I may have had the cell originally formatted as text (why just that
cell? who knows?). Thanks all for the good clues and help!
J Lynch
----- Original Message -----
From: "Joe Conner" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, September 06, 2007 11:21 AM
Subject: Re: [users] Data points on charts
Was the first column formatted as text and subsequent columns formatted as
number before you entered anything? A leading apostrophe (single quote)
will overwrite cell formatting and force a string entry.
JPL wrote:
Thanks again. I think I figured out what it was. Looking again at the
first entry in the first column, it had somehow gotten an apostrophe
entered right before the numerical data entry. This was true in all my
columns (but only the left of the two columns, or the x-values) for all
my data sets. Once I removed the apostrophe, all was fine.
How did the apostrophe get there? And on every first-row, left column
data item. Any thoughts about that?
thnx
J Lynch
----- Original Message ----- From: "JPL" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, September 06, 2007 9:42
Subject: Re: [users] Data points on charts
Thanks for both suggestions about the first row label idea. I've tried
it both ways, with the check box ticked and without; nothing seems to
work.
J Lynch
----- Original Message ----- From: "Richard Travers" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, September 06, 2007 5:12 AM
Subject: Re: [users] Data points on charts
In article <[EMAIL PROTECTED]>,
JPL <[EMAIL PROTECTED]> wrote:
I'm having a problem with plotting a set of data. I've got two
columns.
The first data point (topmost row) won't print in the chart. I've
checked
the data range and its fine. All the other data points plot
correctly.
This happens on every chart.
Any thoughts?
Do you have 'first row as label' ticked when you create the chart?
If so, untick it.
R
--
Richard Travers
[EMAIL PROTECTED]
Truro, Cornwall
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
