software

I keep getting the following pop up error message as I'm creating a line
chart. The source data includes two colums with nearly 900 rows of data.
Basically the data is temperature readings from two probes (coulmn Aamp;B) at 1
second intervals (900 rows = 15 minutes of data) There's also a 3rd column
that has 60 points of data, but this colums in only used to provide the data
for the X axis labels. So by my calculation, I have less than 2000 data
points, correct? Why the error message?

This is what the message says;

quot;The maximum number of data points you can use in a data series for a 2-D
chart is 32,000. If you want to use more than 32,000 data points, you must
create two or more series.quot;

Thanks,
David
There may be data in rows far below the visible data. If you select the
entire column, this will be a problem. Even a space character is enough to
throw off Excel's parsing of your selection.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;DavidJ726quot; gt; wrote in message
...
gt;I keep getting the following pop up error message as I'm creating a line
gt;chart. The source data includes two colums with nearly 900 rows of data.
gt;Basically the data is temperature readings from two probes (coulmn Aamp;B) at
gt;1 second intervals (900 rows = 15 minutes of data) There's also a 3rd
gt;column that has 60 points of data, but this colums in only used to provide
gt;the data for the X axis labels. So by my calculation, I have less than
gt;2000 data points, correct? Why the error message?
gt;
gt; This is what the message says;
gt;
gt; quot;The maximum number of data points you can use in a data series for a 2-D
gt; chart is 32,000. If you want to use more than 32,000 data points, you must
gt; create two or more series.quot;
gt;
gt; Thanks,
gt; David
gt;
Thanks Jon, That's what it was.
Davidquot;Jon Peltierquot; gt; wrote in message
...
gt; There may be data in rows far below the visible data. If you select the
gt; entire column, this will be a problem. Even a space character is enough to
gt; throw off Excel's parsing of your selection.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services - Tutorials and Custom Solutions -
gt; PeltierTech.com/
gt; 2006 Excel User Conference, 19-21 April, Atlantic City, NJ
gt; peltiertech.com/Excel/ExcelUserConf06.html
gt; _______
gt;
gt; quot;DavidJ726quot; gt; wrote in message
gt; ...
gt;gt;I keep getting the following pop up error message as I'm creating a line
gt;gt;chart. The source data includes two colums with nearly 900 rows of data.
gt;gt;Basically the data is temperature readings from two probes (coulmn Aamp;B) at
gt;gt;1 second intervals (900 rows = 15 minutes of data) There's also a 3rd
gt;gt;column that has 60 points of data, but this colums in only used to provide
gt;gt;the data for the X axis labels. So by my calculation, I have less than
gt;gt;2000 data points, correct? Why the error message?
gt;gt;
gt;gt; This is what the message says;
gt;gt;
gt;gt; quot;The maximum number of data points you can use in a data series for a 2-D
gt;gt; chart is 32,000. If you want to use more than 32,000 data points, you
gt;gt; must create two or more series.quot;
gt;gt;
gt;gt; Thanks,
gt;gt; David
gt;gt;
gt;
gt;
As a follow up, I've now added a 4th column and am having difficulty in
getting it to display on the chart. What I'm trying to do is create a data
series that shows a desired profile so I can compare actual results against
the desired result. Instead of entering up to 900 points I've entered the
desired temperatures at points along the way at (aproximately) 30 second
intervals which gives me aproximately 30 points of data. but when I go to
source data and add a new series, the data isn't displayed. What I
eventually had to do was carefully move the mouse around a region where I
knew a data point existed, and when the little quot;hover tipquot; popped up I was
able to select the series and select custom markers so they'd appear.

What I expected was a line graph to connect the 30 points. I knew it wasn't
going to be as smooth as one of the other columns that has temperatures
recorded every second, but shouldn't of I expected a line of some sort?
Even after selecting line type amp; color I can't see a line, only the markers.

Any idea's?

Thanks,
David
Never Mind!!

I found it, tools options, interpolated.

David