How Data Visualization in Excel Can Reveal LPG Supply Shortages Across India
A simple analytics technique using Excel map charts
Table of Contents
India’s LPG Consumption Challenge Understanding the Dataset Creating Map Visualizations in Excel Why Data Visualization MattersIndia’s LPG Consumption Challenge
India consumes tens of millions of tons of LPG every year, making it one of the largest energy markets in the world. A significant portion of this fuel is imported, which means supply disruptions can directly impact households across multiple states.
Understanding where shortages occur becomes critical for policymakers and businesses managing supply chains.
Understanding the Dataset
In a typical analytics scenario, a dataset may include information such as the number of LPG consumers in each state, monthly cylinder demand, total supply, and the resulting shortage.
When this raw data is organized properly, analysts can quickly identify patterns and understand how shortages differ from one region to another.
Creating Map Visualizations in Excel
Excel offers a surprisingly powerful visualization feature known as **Map Charts**. After organizing the dataset by state and shortage values, users can insert a map chart directly from the Excel ribbon.
Once created, the map highlights regions based on shortage levels. States with higher demand pressure appear in darker shades, making it easier to interpret supply distribution visually.
Interactive elements such as slicers can also be added, allowing users to filter locations and examine specific states individually.
Why Data Visualization Matters
Projects like this demonstrate how data analytics transforms raw numbers into meaningful insights. Instead of scanning large spreadsheets, stakeholders can instantly see where supply gaps exist.
Visualization tools help analysts explain complex business or policy challenges clearly — whether it’s energy distribution, logistics planning, or market forecasting.
If you're interested in learning practical data analytics techniques like this, tutorials and examples can help you understand how real-world datasets are analyzed.
Comments