Dynamic WordArt in Excel with Bar in Bar Chart

Info-chart that shows % completion (progress bar)

Excel WordArt with Formula and Excel bar in bar charts to show progress

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.

Free Excel Download

The new Excel Dashboards course is here!

Now available on Udemy

Visually Effective Excel Dashboards for your reports.
Redeem your coupon for 75% off below.

Free Ebook

One Comment

  1. Muhammad February 13, 2018 at 8:42 am - Reply


Leave A Comment

Share This