Visualization

The Bad Way To Create An Excel Enterprise Dashboard (And What You Can Do About It)

Every organization needs to know its numbers and an Excel Enterprise Dashboard is an awesome way to make that happen. It creates a "shared picture" to inform your strategy, your direction and your current work, while leveraging existing Excel skills. That value is HUGE.  But many organizations do it the wrong way. Check out the [...]

By | December 4th, 2014|Enterprise Reporting, Excel|0 Comments

How did Nashville score on the ACT?

7,443 MNPS students took the ACT over two years. How did they do? Below is an infographic of how they did if the 7,443 students were a class of 25 students. In Tennessee, a minimum ACT test score of 19 is the entrance requirement for state colleges and universities. An ACT score of 21 is the minimum necessary to [...]

By | October 6th, 2014|Excel, Office 365|4 Comments

Creating Infographics with Excel, Part 3

In this post, we are going to try something more advanced. If you feel lost, try starting with Part 1. Hopefully this will inspire you and give you a flavor of what types of infographics you can create with Excel. Our subject is going to be high schools in Nashville. We are going to create [...]

By | September 26th, 2014|Excel|0 Comments

Creating Infographics with Excel, Part 2

In my last post, I described the basic steps to create an infographic in Excel: put a cut out image in front of a bar chart. However, I did not explain how to create the all-important cut out image. In this post, I will explain how to create any cut out image. True confession...I was dreading [...]

By | August 30th, 2014|Excel|0 Comments

Creating Infographics with Excel, Part 1

Infographics are powerful communication tools.  This is evidenced by how popular they are in magazines and newspapers.  Graphic designers usually create infographics through a manual process. What if you could create an infographic that updates with the change of a slicer? That would be powerful! Live Example: See this example in Excel Online. The basic construction is [...]

By | August 19th, 2014|Excel|0 Comments