asked on November 10, 2015
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
⋅ 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
⋅ 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
⋅ 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
⋅ 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
⋅ 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
⋅ 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
