Let’s get creative with Excel!
In this tutorial we’re going to combine Word Art together with Excel charts to create an impressive progress bar.
This progress bar is a part of the % sign of our Word Art. The result is the icon for this blog post.
The thing with Word Art is that you can’t conditionally format it without using some VBA code. If you’d like to avoid macros, you can still get creative and combine a mini bar chart with the % sign to get the progress bar.
This will be an impressive visualization for your project progress presentations or for your Excel Dashboards and interactive reports.
We specifically cover two topics here:
- How to have dynamic word art that is controlled with a formula
- How to create bar-in-bar Excel charts
…and as a bonus we put them together to create an info-chart.
Watch the steps in this video:
Feel free to Download the Workbook HERE.
Excel Dashboards that Inform & Impress