plots with 10000 lines of data

**pvp4010** · 02-15-2009, 05:22 PM

Hi,

I am running into a situation wherein excel gets too slow and unstable.

My issue is that i have around 10000 data points to plot BUT not more than 50 of those are NON zero values and all i need to do is plot only the non zero values. anybody aware of a way to fish out only those nonzero values[ofcourse other than manually copy-pasting them].

thanks in advance

Regards
pvp4010

**mrice** · 02-15-2009, 05:56 PM

Not sure what sort of graph you are plotting but you could try deleting the non-zero values. A simple way to do this is to use the find/replace (Control H) and replace zero with nothing.