6 charts for lively progress visualization

There are several different charts in Excel that can help you to create a perfect progress illustration.

    1.    Simple gauge chart

This simple chart resembles a speedometer gauge and displays a value between 0 and 100%:

The gauge Chart in Excel 2013 The gauge Chart in Excel 2013

See Creating a gauge chart for more details.

    2.    Simple bar chart

You're probably familiar with a "thermometer" type display that shows the percentage of a task that's completed:

The thermometer Chart in Excel 2013

See Creating a simple thermometer chart for more details.

    3.    Glossy thermometer chart

Thermometer chart is nice indicator of the process with well-defined measure, e.g. task status. You can create more interesting thermometer chart in Excel:

Glossy thermometer chart Excel 2010

See Creating a glossy thermometer chart for more details.

    4.    Semaphore chart

Data visualization is a key cognitive tool that enables you to attract more attention to your statements. E.g., you can direct your organization attention to insufficiently developed goals and praise them for successfully performed goals:

The semaphore thermometer Chart Excel 2013

See Creating a semaphore thermometer chart for more details.

    5.    Rainbow chart

Creating a thermometer chart, you are not limited to a single-color bar. Instead you can specify different colors for different value intervals:

The rainbow thermometer Chart Excel 2013

See Creating a rainbow thermometer chart for more details.

    6.    Cocktail chart

Do you want to make your annual company performance meeting less boring? Create a funny cocktail chart for it! E.g., you can mix in a glass percentages of department contribution to the company revenue:

The Coctail Chart Excel 2013

See Funny thermometer Cocktail chart for more details.

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.