How to interrup a serie in a chart.

[Roger]

I am trying to interrupt a serie in a chart.
This means do not graph any value for a specific
category, the value 0 has different interpretation.

I'm loading the series values from a literal using the
following code:

'Set the chart type of the serie
MyChart.SeriesCollection.Item(i).Type =
OWC10.ChartChartTypeEnum.chChartTypeLine

'Set the categories and values using a string.
MyChart.SeriesCollection.Item(i).SetData
(c.chDimCategories, -1, strCategories)
MyChart.SeriesCollection.Item(i).SetData(c.chDimValues, -
1, strValues)

The strValues is separate by Tabs.
I'm working with ASP.NET and OWC10.

Note: This is possible to do using Excel without data in
a value cell.

Thanks in advance!

 

[Mark S]

this link may help:
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;q286317