Better Excel Progress Charts in 3 EASY STEPS

So, you want to share the status of your projects. Well, your boss doesn't just want to read these numbers. They want to visualize the progress. Make it easy for them and do it the pro way. Let's do it from scratch. Step one, bring the numbers over to the next column. Step two, select your range. Go to conditional formatting, data bars, more rules. Step three, and here's where a lot of people make a rookie mistake. They leave minimum and maximum to automatic. But because our progress goes until 100%, we want to set minimum to a number zero and maximum to a number one. Select the color of your choice. I'm going to go with this blue. Place a check mark to show bar only. And okay. And that's it. We have a fully dynamic progress bar. Super easy. Catch you in the next