How to remove empty series from Multi Axis chart

[terija129]

Hi,

I have columnline chart in JasperSudio 6.3. that shows too many series. Data is in below format. I need to show Valuation A on secondary chart and rest on primary. How can series that have only null data be removed from chart? 

 

Date	Valuation	Value	MarketValue
2016-03-31	A	-	200
2016-03-31	B	175
2016-03-31	C	500
2016-06-30	A		210
2016-06-30	B	670
2016-06-30	C	550
2016-09-30	A		200
2016-09-30	B	600
2016-09-30	C	550

 

[elizam]

For charts in the community edition (based on JFree Charts), you might need to write a chart customizer.  (Does community edition support column/line?)

For HTML 5 charts (underlying engine is HighCharts), there seem to be some methods available for series you might be able to use:

http://api.highcharts.com/highcharts/Series.hide

 not sure if that works for column/line, bust asking on the highcharts forum might also get you some insight. Note that not all methods and options from highcharts have been tested in Jasper, so in some cases they don't work. But many of them do.