🔥 Create a Live India Map in Excel Using Petrol Price Data (Step-by-Step Guide)
You can create a live India map in Excel by selecting state-wise data and using the Filled Map chart under Insert → Maps. It automatically visualizes regional data like petrol and diesel prices.
Raw data like petrol and diesel prices across Indian states can feel overwhelming. Instead of using boring tables or simple charts, you can turn this data into a powerful visual India map using Excel.
This technique helps analysts, business users, and students instantly understand regional price variations and trends.
- Create Map Chart
- Customize Design
- Add Labels
- Switch Between Petrol & Diesel
- Advanced Map Settings
📊 Step 1: Prepare Your Data
Start with a dataset containing:
- State names (e.g., Maharashtra, Bihar)
- Petrol prices
- Diesel prices
Excel will automatically recognize geographic locations if your state names are correct.
🗺️ Step 2: Create a Filled Map Chart
To convert your data into a live map:
- Select your data columns
- Go to Insert
- Click on Maps
- Select Filled Map
Excel will instantly generate a visual map of India showing price distribution. :contentReference[oaicite:0]{index=0}
🎨 Step 3: Customize Map Design
- Click on the map chart
- Go to Chart Design
- Select Change Colors
- Choose a theme (e.g., orange for clarity)
This improves visual impact and readability.
🏷️ Step 4: Add Data Labels
Enable labels to see exact values:
- Click chart → Data Labels
- Show state-wise prices
Now you can clearly view petrol prices for each state like Maharashtra, Bihar, or Odisha.
🌍 Step 5: Advanced Map Settings
- Right-click → Format Data Series
- Choose Only Regions with Data
- Enable Show Fit Only
This ensures only relevant states are highlighted while others remain hidden.
🔄 Step 6: Switch Between Petrol & Diesel
To visualize diesel prices:
- Copy the chart
- Replace petrol data with diesel data
Now you have two powerful visual comparisons in seconds.
🔥 Why This Matters
- Instant regional insights
- Better decision-making
- Professional dashboards
- Great for business presentations
❓ FAQs
What is Excel Map Chart?
It visualizes geographic data like states and countries.
Does it work for India?
Yes, Excel recognizes Indian states automatically.
Is it beginner friendly?
Yes, no coding required.
Comments