avoid the 0 value plot on FoxChart

Topics: General
Sep 11, 2009 at 2:08 PM

Hi! I'm using FoxCharts and I like it! But....the only thing that I wasn't able to do is to avoid the plotting of zero values.

For Example: line chart with the following series

serie1: 1,2,3,4,5,6,7,8,9,10 on x axis

serie2: 10,15,45,65,78,88 on y axis

serie3: 0,0,0,5,0,0 on y axis

for the serie3 I want only a point to be displayed and not 0 value, now it look like this; ____/\____ and it's not correct.

How to do this? the series are on a table with numeric fields.

Using VFP9 Sp2 and Sql Server 2005



Sep 11, 2009 at 2:20 PM

ok Solved!

Sep 11, 2009 at 3:19 PM

Now that you've solved your problem, could you share your suggestion with others?

I would have suggested replacing the zeroes with nulls.

Jim Nelson

Sep 11, 2009 at 6:12 PM

Right! Just replacing the zeros with NULL


for now it seems working!

thanks guys!


Feb 8, 2011 at 5:31 AM

The solution of null is not so good.

Infact, if later I need to make an update of a value, for example 5,15, the null makes the value replaced as 5 cutting off the decimals.

any other ideas? why not a property on foxchart like other stuffs: show zero values T or F???