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.