Let's be honest, Smartsheet dashboards offer a fairly limited chart library. You get your classics: pies, bars, lines, and scatter plots, with a few variations of each so creativity quickly becomes a necessity.
There are clever workarounds out there, like this community-built speedometer chart, but as you can probably tell, it's not exactly a quick build.
Given those constraints, I think the better approach is to master what is already available and squeeze as much value as possible out of the native chart types.
My favourite is the stacked bar chart. It's the most versatile chart in the toolkit, and it works across a surprising range of use cases. Here are four of my favorites:
This is the stacked bar chart in its most traditional form: positive values stacked above the axis, negative values below. It's ideal for showing revenues and costs by month, for example. You can pair it with a simple bar chart showing the monthly balance, or a cumulative version that tracks the running total throughout the year.
Another classic use, breaking down a count of items by category. Clean, readable, and instantly familiar to any stakeholder. The horizontal variant works particularly well when you have long category labels.
Most people would use the half-donut chart for RAG indicators, and I do too sometimes. But I find the arc shape can distort perception. The middle segment appears taller and therefore more prominent than it really is. A stacked bar keeps all three statuses visually comparable and on equal footing.
It's also a practical space-saver on a crowded dashboard.
This is my personal favorite application of the stacked bar chart, and the one I find most underused.
When managing a portfolio of projects, it's easy for updates to slip through. Project managers miss their deadlines, fields get left blank, or entries contain errors. Conditional formatting on your portfolio sheet can flag these issues, but how do you surface that information quickly to leadership or PM managers?
The principle is straightforward (elegant even, if you allow me), every row in your chart must total the same value: the total number of items in your list (projects, in this case). You then divide each row into three segments:
(Those are the best labels I've found, let me know if you have better taxonomy.)
This is typically built through an intermediary metrics sheet that calculates these three counts per project manager or time period. The result is a chart that makes gaps and errors visible at a glance, no digging required.