asked on January 27, 2023
Hi!
I would like to know, would it be possible to display stacked column charts for multiple measures instead of the stacks representing a dimension?
Also when there are multiple dimensions shown in the chart on X axis, if the first row of those needs to be rotated to conserve space, the other rows become rotated as well even though they could fit horizontally and it would save a LOT of vertical space.
Thank You!
István
⋅ January 27, 2023
Hello, István!
Thank you for contacting us.
Kindly note that in Flexmonster Pivot Charts it is possible to create a stacked column chart for only one measure.
However, we offer integration with 3rd party charting libraries, where the multiple-measure stacked column chart can be created.
We have prepared an example of the stacked column chart with multiple measures using the Highcharts charting library for reference: https://jsfiddle.net/flexmonster/x1pLz7qa/.
You can find more details about integrations with 3rd party charting libraries in our docs: https://www.flexmonster.com/doc/available-tutorials-charts/.
Regarding your question about rotating the x-axis labels while drilling the chart, we agree that, in some cases, the mentioned rotating behavior can be omitted. Our team has added your improvement suggestion to our customers' backlog.
For now, we kindly recommend increasing the size of the container or using the fullscreen mode as a possible workarounds.
Hope you will find our answer helpful.
Feel free to contact us in case of any other questions.
Regards,
Solomiia
⋅ January 27, 2023
Thank You for the answers. The problem with 3rd party libraries is that although they support stacked charts, they don't support category grouping (multiple x axis labels). There are workarounds, but they are always just hacks and not officially supported. Any library you could recommend which supports both?
⋅ January 30, 2023
Hello, István!
Thank you for getting back to us.
Kindly note that Flexmonster Pivot Charts have all pivoting functionality that is available for the Flexmonster grid view.
On the other hand, charting libraries are mostly developed for visualizing data and have no such functionality.
However, some of them, e.g., the Highcharts or Google charts, offer drilling functionality, as in the example: https://jsfiddle.net/flexmonster/qf73smhf/.
Hope you will find our answer helpful.
Kind regards,
Solomiia
