Clustered column question.

Nateksi · Post by **Nateksi** » Tue Sep 30, 2008 8:00 am

Hi,

I want to make a clustered column chart where a column doesn't show or make a space if its value is zero. Right now it make a space where the column would have been if there had been any data...

How do I get this done?

Thank you
/Anette

Post by **Edward** » Wed Oct 01, 2008 1:34 am

Hello, Anette.

If you need a chart for example for 12 months, but a datasource has only 11 records in it, then you need to extend your data up to 12 records in order to receive 12 bars instead of 11 in chart. There is no other options.

Thank you.

Nateksi · Post by **Nateksi** » Wed Oct 01, 2008 2:45 am

okay, but thats not my problem. I would like to make a chart with like 4 columns, but if one of the values is zero in the datasource then I want the column to disappear and not make a space.

/Anette

Post by **Edward** » Wed Oct 01, 2008 9:03 am

Yes, it is possible. Please set Filter property of the Chart:

Value Numeric ColumnName not equals 0

Thank you.

Nateksi · Post by **Nateksi** » Thu Oct 02, 2008 2:29 am

Hi again,

I've tried the filter like you said, but there's still a space where the column would have been if the value had been greater than 0. I don't want that space...

/Anette

Post by **Edward** » Sun Oct 05, 2008 2:37 pm

Hello, Anette.

Please send the report template to support[at]stimulsoft.com for analysis.

Thank you.