March 16, 2021
I have been working on a layered doughnut chart - two charts on top of each other - for a dashboard.
Green is current inventory on hand, beige inventory on order, and grey is inventory allocated to projects. Red indicates an inventory shortfall if this scenario is present.
I would be keen to know if there is a 'better' / 'easier' way to achieve this style of visuals for on a dashboard?
What other styling might / could be added to improve the visuals?
A further question, as this is two doughnut charts layered on top of one another, is there any way to grab both charts and link then together so that when you grab the top one and more it the bottom one comes also?
Appreciate thoughts in input.
July 16, 2010
Welcome to our forum!
Personally, I wouldn't use a doughnut chart. I think they take up way too much space and they're difficult for your users to read at a glance, which we should be striving for with our dashboards.
I'd use a bullet chart, which is just a stacked bar chart with one series (allocated) on the secondary axis so that it sits on top of the stock data. See example file attached.