The Yamazumi chart – also known as the operator line balance chart – is a load chart that breaks down the individual work tasks in a process, detailing the time they take. Obviously, it’s used in lean six sigma to good effect. You can download my version of the chart here.
While there are lots of different ways to plot this data, often a stacked bar chart is used (especially in Excel), usually in combination with another chart to show the % Waste, VA and NVA. The point though, is to help you to identify Value Added activities (VA), Non-Value added Activities (NVA) and Waste activities, so that you can work on reducing NVA and Waste.
Having been asked to help a colleague with a lean dashboard I did some research on the subject and found some great examples online. One chart in particular by Adaptive Business Management Systems is particularly good having a stacked bar chart with a pie chart to show the 2 sets of data. You can download their version for your personal / commercial use. It even comes loaded with vba to update the chart as needed.
There are even online versions, like this one by Lean Lab.
Personally though I’d prefer to have all my information in one chart, have it organized and show very simply where I need to concentrate. It took a bit of work, but I came up with this version, a stacked bar chart with the VA, NVA & Waste plotted on the secondary axis behind the individual tasks. Basically any task that falls within the red (Waste) or yellow (NVA) areas needs to be eliminated / reduced. I’ve put the task name and category in the data label to make it clearer, similar to the ABMS version above.
From the chart it’s clear to see that process 3 is already streamlined, whereas processes 1, 5 and 6 need the most work.
You can download my sample workbook and chart here if you wish to use it. Let me know what you think! Obviously this is still in draft form. I need to add vba to make it update automatically as new data is added and I’ll probably tweak the formatting further – remove the visible secondary axis for example, but overall I’m pleased with the results.
Hope it helps!