INFO GRAPHICS WITH EXCEL

I’m not always the biggest fan of info graphics. Many of the posters-sized info graphics released these days have issues. But lately I’ve also received several requests on how to do info graphics with Excel. Many people don’t know where to start.

How Info Graphics are Different
Info graphics differ somewhat from your usual dashboard-style reporting. When we report with business tools, we use the data points–charts, tables, etc–to investigate a problem or monitor a system. That is, we use data to find results. Info graphics are used when we already know the results and we want to present it in an interesting, sometimes even artistic, way. Info graphics, then, are more about style and appearance–they wouldn’t necessarily find a good home on a dashboard. But they do work well in magazines, newspapers, and some student projects.

Info Graphics and Excel
Many info graphics are made with graphic editing programs like Adobe Illustrator. As far as I know, these illustrations are static. So each change in the underlying data won’t be automatically updated in the graphic. You would just have to redraw the graphic. Excel provides a benefit here: if we use Excel’s charts to make our info graphics, we can update the underlying data and the result appears automatically.

Read more at INFO GRAPHICS WITH EXCEL

Write your opinions about this article below and subscribe us for the latest article in your inbox.

Dashboards Help CIOs Manage Business Services

CIO.com has recently released an article introducing the following 6 business dashboards by putting data from a variety of enterprise applications and services at a CIO’s fingertips so he or she can better manage employees, website activity, development projects and company resources.

Kapta Dashboard

Kapta shows a summary of employee goals in an easily identifiable red, yellow and green—map to the overall company goals with a heat map. The map shows a breakdown of the percentage completion rate by groups within IT.

Continue reading