Categories: Visualizations

Open your Excel Application and Plead for Forgiveness

Reading Time: 2 mins

Gramener’s Richie Lionell writes in defense of Excel

I come from a tribe whose first brushes with data visualization began with Excel. It all started when my former boss in early 2011 said, “Have you heard of charts that fit into an Excel cell? Please can you find out what that is all about?” In-Cell charts were an eye-opener but thankfully my eyes were also opened to what one could do with shapes, colors & tweaked charts. The world of Python, D3.js, design & story telling then beckoned me and it was hard to resist. I took the plunge but in the overflow of joy that followed I haven’t left Excel behind.

Excel????? – People cringe and then I show them a few unconventional visuals we’ve created using Excel;

Visualizing Dry Days in India – 1977 to 2005

A 0.5 grid Lat-Long weather map of India we created on Excel cells – supported by VLOOKUP, IFERROR, a scrollbar & conditional formatting – is a major draw at our Dataviz trainings. It is a visualization of dry days in every 0.5 degree Lat-Long grid from 1977 to 2005. No images or shapes were used. Yup, no VBA too & created using Excel 2010.

How about using Excel for some story telling? This one is the story of Hollywood stars, the data coming from an Excel table.

Story Telling through Excel

No, the pictures of the celebrities are not images. They are Dingbat fonts (Ever wondered the use for Webdings & Wingdings?). No VBA here too, just the usual suspects – VLOOKUP, IFERROR – and a bunch of radio buttons.

Here’s a simulation of a chess game (Dingbats again).

Simulating a Chess Game in Excel

You can do all of the above using Excel 2007. Yes, you read that right. Now open your Excel application and plead for forgiveness. With this newfound respect for Excel you can now learn how to Visualize Sensex returns in Excel.

Gramener - A Straive Company

Gramener – A Straive company is a design-led data science firm. We build custom Data & Al solutions that help solve complex business problems with actionable insights and compelling data stories.

Leave a Comment

View Comments

Share
Published by
Gramener - A Straive Company

Recent Posts

How Does Computer Vision Help With Managing Perishable Goods?

The global food industry faces significant losses daily due to the spoilage of perishable goods.… Read More

1 week ago

Enhancing Warehouse Accuracy with Computer Vision

In today’s fast-paced world of e-commerce and supply chain logistics, warehouses are more than just… Read More

3 weeks ago

How AI is Redefining Quality Control and Supercharging OEE Optimization?

What does it mean to redefine the future of manufacturing with AI? At the heart… Read More

1 month ago

How is AI Transforming Cold Chain Logistics in Healthcare?

In 2022, Americans spent USD 4.5 trillion on healthcare or USD 13,493 per person, a… Read More

1 month ago

How Can CEOs Slash GenAI Costs Without Sacrificing Innovation?

In the rush to adopt generative AI, companies are encountering an unforeseen obstacle: skyrocketing computing… Read More

2 months ago

Top 7 Benefits of Using AI for Quality Control in Manufacturing

AI in Manufacturing: Drastically Boosting Quality Control Imagine the factory floors are active with precision… Read More

2 months ago