How to generate graph in Excel with more than 4000 points

[Raguraman]

I have a problem of generating a graph in excel with more than 4000 data points. Is it possible to generate a graph in excel with more than 4000 points. If it is possible kindly help me to do that.

Raguraman. J.

[Darren]

It is not possible to plot 4000 or more points in an Excel graph.  This is a limitation of the Microsoft Graph component of Excel.  The easiest workaround is to decimate your data to a size less than 4000.

-D

[shoneill]

Darren,

4000? I thought the limit was 32000.....

Is this an internal Excel limitation or some toolkit?

Curious

Shane.

[Darren]

To my knowledge it is 4000.  I think the 32000 limitation applies to the actual rows/columns in the spreadsheet.  If you launch the data editor for a graph/chart in Excel, you'll notice that the table for the graph/chart data only has 3999 columns.

-D

[Conseils]

I think that you should pay attention to the version of Excel that you are referring to as well!

Different versions have different limits.


Just out of intereset, why where 4000 data points needed? You can't see them on a standard display (monitor) and I would be interested to know if the printer driver actually bothers to create that level of detail on the hard copy?


What we do is create multiple graphs with summary averaged data and zooms of places of interest.... if that helps any.

[Process_Systems]

You may be running into trouble by trying to input your data into a single row. Try using the "transpose" option of the save to spreadsheet vi. This will put your data into a single column, where you have the 32K limit. I have done this many times with no hassle, even in Excel 97.
Hope this helps.

Dave

[rotator]

I think the 32k limit applies to 2D chart and the 4k limit applies to 3D chart

[ade77]

In Excel 2007 you are limited only by the memory of your PC, you can plot as long as your number of columns or row, but in 3D plot you are limited to 4000 points as the earlier poster had suggested.

If you are haveing problem plotting 2D- 4000 points, then the problem is the memory in you PC