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?
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?
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?
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.
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?
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.
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.