Multiple lines in a column line chart

0

Hi, i've recently been tasked with automating some dashboards using Jasper. I want to create a chart displaying several columns and lines, but i can only ever get one line. The rest of the data is always shown as columns.

The data on the linked image is irrelevant but showcase my issue well. Here i'd want "Foreign Currency Amount" to be displayed as a line, just like "Currency rate".

Is there a hidden option that would allow that ? Or maybe in the advanced windows in Chart Format options. Maybe i could create two Ad Hoc Charts, one with columns the other with lines, and combine them when i create a new dashboard. I'm open to all solutions.

Thanks alot.

 

PS: Had to choose a "Related Project", since i don't know what to chose, i picked randomly :/

paul.lauruol's picture
Joined: Jul 1 2019 - 2:44am
Last seen: 1 month 2 weeks ago

1 Answer:

0

If jrxml chart is an option then see attached for example.  Main step is the advanced properties tab to make the type an 'spline'.  But Ad Hoc chart has more limiting capabilities so I am not sure whether it can be applied to the Ad hoc. 

Attachments: 
AttachmentSize
Package icon testcolumnspline.zip117.23 KB
vchiem's picture
4596
Joined: May 1 2017 - 5:33pm
Last seen: 4 hours 41 min ago
Feedback