Menu
Download Free Trial

Change Individual Series Chart Type

Is it possible to change the series chart type for an individual series on a chart? Say I have 4 measures charted, and I want three to display as a bar chart series, and the fourth to display as a line – how would I go about this?

Thanks,
Ben

6 answers

Public
Ian Sadovy Flexmonster November 10, 2015

Hello Ben,
 
Thank you for the question.
There is a “bar_line” chart type, that shows 2 measures on the one chart: first as bar, second as line.
 
Does it work for you?
 
Regards,
Ian

Public
Benjamin Kidder November 10, 2015

Hi Ian,
I’m aware of the bar_line chart type, but that only displays 2 measures. If there is a third measure, how can I display all three? Say I want measures A and B as bars, and measure C as a line – what’s the best way to handle that scenario?
Regards,
Ben

Public
Ian Sadovy Flexmonster November 10, 2015

Ben,
 
Unfortunately, there is no option to create such layout on charts as you’ve described.
But it’s possible to show 2+ measures on the chart of one type (i.e. bar) using “Multiple values” option (please check the demo).
Hope this helps.
 
Regards,
Ian

Public
Benjamin Kidder November 10, 2015

Hi Ian,
In that case, what is the best method for accessing the data in the grid so that I can plug it into a different chart control? Is there a property I can reference, or will I have to call the getCell() function repeatedly?
Regards,
Ben

Public
Ian Sadovy Flexmonster November 11, 2015

Hi Ben,
 
Yes, you have to call getCell() function repeatedly (there is no other way to access the data from the grid).
Also, such feature as integration with the third-party chart libraries (i.e. Highcharts, FusionCharts) already exists in our roadmap.
 
Regards,
Ian

Public
Tanya Gryshko Flexmonster December 5, 2016

Hello Ben and all Flexmonster users,
We are glad to inform you that starting from version 2.3 it is possible to retrieve the data that pivot instance is showing via new API call getData(). Read more in API reference: http://www.flexmonster.com/api/getdata/. Thus in version 2.3 you can use Flexmonster pivot table with any 3rd party visualization tools. Find all the details in the documentation: Highcharts, FusionCharts, Google Charts and any charting library.
Regards,
Tanya

Please login or Register to Submit Answer