Hi @stefanof good to hear from you–thanks for reaching out!
Can you share more about what you mean by an overlapping bar chart? Feel free to share an image or mockup
Hi @ajl5 , how are you ? thanks for your prompt reply. I’ll try to explain …
I have a chart for a company income statement, with 4 values (revenues, cost of sales, operating expense and net income). Currently I use the “Bar” chart type in the Chart-Bar/Line/Area element and it looks like this (showing 2 periods):
It’s not bad but it would be more understandable if the bar were stacked. Changing the chart type to “Bar Stacked” I get to this:
As the chart type name tells, data series are stacked. Unfortunately in this use case the data view is meaningless. What I need is an overlapping series view where each data series starts from zero and series 4 (dark red) overlaps series 3 (blue) which overlaps series 2 (yellow) which overlaps series 1 (revenues). No opacity is needed since we can already manage the color of each series in the plugin element.
Final result should look like this:
As you can see, if in one month the net income is negative it simply goes below zero.
I have seen that this feature is available in some libraries but it would be really nice to be able to stick with your plugin for all client apps.
Thanks
Stefano
Hi @stefanof thanks for the additional detail here!
We’ve pushed an update in v5.3.23 that should hopefully help you with your use case. There is now a new chart type called “Overlapped Bar (Vertical)” in the dropdown menu. Please note that the on the element properties (Series 1 - 6 data), the earliest series will be closest to the “front”. In other words, if there are two series of data (series 1 and series 2, series 1 bars will be in front of series 2).
Can you please upgrade and let us know if this helps you with your use case?
Absolutely amazing ! Thank you @ajl5
This is the P&L chart with 4 series (sales, cost of sales, sg&a, ebit) and 1 y-value.
And this is the P&L chart with the same 4 series and 3 y-values.
There is only one small downside that I did not consider in the request (my fault).
As you can see in the second chart, the blue bar is not visible. It’s hidden in the back of the red bar since the SG&A expense amount is lower than the EBIT amount.
It would be perfect if the series overlapping order was dynamic, based on the series values. The larger amounts should be in background while the smaller amount are overlapping in front.
I mention this aspect only for completeness . For 90% of my use cases it is fine the way it is. Just wanted to let you know the full results of my test.