hide some data in multi series charts

[tztun]

i am creating a multi series column 3D chart and i'd like to know if i can hide some values.

For example, Sales data for companies group by month and company A has 0 values for the month of  July, August,etc and I want to hide those '0' columns.

When i set the values as <set value=''/>, it hide the column but leaves a gap between columns. I'd like to know if there is a way to hide insignificant data from the chart.

Thanks in Advance.

[Sanjukta]

Hi,

 

 

 

The best way to keep a data plot hidden without leaving a gap is to remove that particular <set> element altogether from the XML of the chart.

 

 

 

Hope this helps.