Log In
Register
Home
New Member
Dashboards
Power Query
Power Pivot
March 16, 2021
Offline
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.
See Answer
July 16, 2010
Offline
Hi Scott,
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.
Mynda
Answers Post
1 Guest(s)
