Excel Dataviz Tutorial: Show Max, Min, & Scores for multiple criteria

I created this visual based on a request from a student in the Master of Finance program at Queens University. They asked how to visually show the scores on multiple criteria for the organizations they were analyzing. I created a bar chart for each criteria that shows the score, how far it was from the maximum score, and calls out the minimum score and maximum score for each criteria. It is all created as a single stacked bar chart in Excel. This video shows you how you can create this type of data visual yourself using just plain vanilla Excel.

By Dave Paradi

Dave Paradi has over twenty-two years of experience delivering customized training workshops to help business professionals improve their presentations. He has written ten books and over 600 articles on the topic of effective presentations and his ideas have appeared in publications around the world. His focus is on helping corporate professionals visually communicate the messages in their data so they don't overwhelm and confuse executives. Dave is one of fewer than ten people in North America recognized by Microsoft with the Most Valuable Professional Award for his contributions to the Excel, PowerPoint, and Teams communities. His articles and videos on virtual presenting have been viewed over 4.8 million times and liked over 17,000 times on YouTube.