Analyze India's Economy in Excel

Turn World Bank data into an Excel dashboard tracking India's GDP growth.

Introduction

30 Second Summary

Every headline about India's booming economy is backed by raw data that someone had to clean, organize, and visualize. That someone is a data analyst, and the tool they reach for most often is Excel.

In this project, you will download real economic data from the World Bank, clean and structure it in Excel, build formulas for deeper insights, and create a visual dashboard that tracks India's GDP growth, inflation, and rising income from 2000 to 2024.

What You'll Build

You will build a multi-sheet Excel workbook that combines three World Bank datasets into a formatted analysis table, Pivot Table summaries, and a one-page chart dashboard.

By the end of this project, you'll have:

  • A cleaned Excel Table combining India's GDP growth, inflation, and GDP per capita data from the World Bank.
  • Formulas using IFS and XLOOKUP that categorize growth years and calculate real economic expansion.
  • A Pivot Table summarizing performance by decade, plus a chart dashboard with conditional formatting.
  • Secret Mission: Add China's data and build a side-by-side growth comparison chart.

Are there any prerequisites?

You need Microsoft Excel (Microsoft 365) installed on your computer. No prior Excel experience is required.

Download and Import India's Economic Data

Every data analysis project starts with sourcing reliable data. The World Bank maintains one of the most comprehensive open databases of economic indicators for every country, updated annually and free to use.

In this step, you will download three key indicators for India (GDP growth, inflation, and GDP per capita) as CSV files from the World Bank. Then you will import them into Excel and get familiar with the raw data structure.

In this step, get ready to:
  • Download three CSV files from the World Bank website.
  • Import the CSVs into a new Excel workbook.
  • Explore and understand the raw data structure.
Download three CSV files from World Bank Open Data

The World Bank provides free, open access to development data for every country. You will download three separate indicators for India, each as its own CSV file.

What is this indicator?

The indicator code NY.GDP.MKTP.KD.ZG measures GDP growth as an annual percentage. It tells you how fast or slow the economy expanded each year.

You should now have three CSV files saved in your Downloads folder.

What are these three indicators?

  • GDP Growth (NY.GDP.MKTP.KD.ZG): How fast the economy grew each year, as a percentage.
  • Inflation (FP.CPI.TOTL.ZG): How fast prices rose each year, as a percentage.
  • GDP Per Capita (NY.GDP.PCAP.CD): The average economic output per person, in current US dollars.

Don't see the Download button?

The Download button sits near the chart on the indicator page. If you landed on a different page or the data table view, scroll up to the chart area. The button may appear just to the right or just below the chart depending on your screen size.

help me find the Download button on the World Bank data page

Import the CSV files into Excel

Each CSV file contains all countries' data for that indicator. You will load each file into its own sheet within a single workbook.

  • Open Microsoft Excel and create a new blank workbook.
  • Click the Data tab in the ribbon at the top.
  • Click From Text/CSV in the Get & Transform Data group.
  • Navigate to your Downloads folder and select the GDP growth CSV file. Click Import.
  • In the import preview window, confirm the delimiter is set to Comma.
  • Click Load to bring the data into your workbook.

What does From Text/CSV do?

This is Excel's built-in tool for reading external data files. It detects the structure of your CSV (comma-separated values) and places the contents into a worksheet as columns and rows.

  • Repeat the same process for the inflation CSV file: click Data > From Text/CSV, select the file, confirm Comma delimiter, and click Load.
  • Repeat once more for the GDP per capita CSV file.

You should now have three sheets in your workbook, each containing one dataset. The sheets will have auto-generated names based on the CSV filenames.

  • Rename the first sheet (GDP growth data) to GDP_Growth by double-clicking the sheet tab at the bottom and typing the new name.
  • Rename the second sheet (inflation data) to Inflation.
  • Rename the third sheet (GDP per capita data) to GDP_PerCapita.

Confirm your three sheets are now named correctly by checking the sheet tabs at the bottom of the Excel window.

Seeing garbled data or everything in one column?

If all the data appears in a single column, the delimiter was not set to Comma during import. Delete the sheet, go back to Data > From Text/CSV, and make sure you select Comma as the delimiter before clicking Load.

help me fix my CSV import in Excel where everything is in one column

Explore the raw data structure

Before building any analysis, you need to understand how the World Bank organizes its data. This will inform how you clean and restructure it in the next step.

  • Click on the GDP_Growth sheet tab to view that data.
  • Notice the column structure: the first few columns are Country Name, Country Code, Indicator Name, and Indicator Code. After these, each column is a year (1960, 1961, all the way to 2024).
  • Scroll through the rows and find India's row. Look for the Country Code column showing IND.
  • Notice that some year columns contain blank cells. These represent years where no data was recorded.
  • Click on the Inflation and GDP_PerCapita sheets to confirm they follow the same structure.

Why are years stored as columns?

The World Bank CSV uses a "wide" format where each year gets its own column. This is common for time-series data downloads but awkward for analysis. In the next step, you will restructure this into a "long" format with years in rows, which is much easier to work with in Excel.

Your raw data is loaded and ready. Next up, you will clean and restructure this data into a single analysis table that is much easier to work with.

Clean and Structure the Data

Your workbook now has three sheets of raw World Bank data. The problem is that this data is in a wide format with years spread across dozens of columns.

In this step, you will create a clean, structured analysis table that pulls just the years you need (2000 to 2024) into a vertical layout. This is the foundation every formula and chart will build on.

In this step, get ready to:
  • Create a new Analysis sheet with a structured Excel Table.
  • Pull India's data from each raw sheet using Paste Special > Transpose.
  • Format the table so numbers display consistently.
Create a clean analysis table

The raw sheets have years running horizontally across 60+ columns. A vertical layout with one year per row is much easier to work with for formulas, Pivot Tables, and charts.

  • Right-click on any sheet tab at the bottom of your workbook.
  • Click Insert, then select Worksheet.
  • Double-click the new sheet tab and rename it to Analysis.

Now set up the column headers for your analysis table.

  • Click cell A1 and type Year.
  • In cell B1, type GDP Growth (%).
  • In cell C1, type Inflation (%).
  • In cell D1, type GDP Per Capita (US$).

Next, fill in the year values down column A.

  • Click cell A2 and type 2000.
  • In cell A3, type 2001.
  • Select both cells A2:A3.
  • Hover over the small green square at the bottom-right corner of the selection (the fill handle) until your cursor becomes a thin black cross.
  • Click and drag the fill handle down to cell A26.

What is the fill handle?

The fill handle is Excel's way of detecting a pattern and continuing it. Because you selected 2000 and 2001, Excel knows to increment by 1 each row. It fills in 2002, 2003, all the way to 2024 automatically.

You should see years 2000 through 2024 in cells A2 to A26. That gives you 25 rows of data.

Now convert this range into a formal Excel Table.

  • Select the range A1:D26 (click A1, then hold Shift and click D26).
  • Press Ctrl+T to open the Create Table dialog.
  • Make sure My table has headers is checked, then click OK.
  • Click anywhere inside the table. Go to the Table Design tab in the ribbon.
  • On the left side of the ribbon, find the Table Name field. Replace the default name with IndiaEconomy and press Enter.

Why use an Excel Table?

An Excel Table is more than just formatted cells. When you add formulas later, the table automatically expands to include new columns. It also lets you reference columns by name (like [@[GDP Growth (%)]]) instead of cryptic cell addresses.

Pivot Tables and charts also work better when they pull from a named table because the source range updates automatically.

Don't see the Table Design tab?

The Table Design tab only appears when your cursor is inside the table. Click any cell within A1:D26 and it should appear in the ribbon.

If Ctrl+T did not create the table (no banded rows or filter arrows appeared), check that you selected the correct range including the header row.

Help me create an Excel Table from my data range.

Pull data from raw sheets using Paste Special > Transpose

The raw World Bank sheets store India's data in a single row, with each year as a separate column. You need those values running vertically down your Analysis table instead. The Paste Special > Transpose technique flips horizontal data into vertical orientation.

  • Click the GDP_Growth sheet tab at the bottom of your workbook.
  • Find the row where the Country Code column shows IND. This is India's data row.
  • In that row, select the cells for years 2000 through 2024. You can use Ctrl+Right Arrow to scroll across to find the 2000 column header.
  • Once you have located the 2000 column, click India's value in that column, then hold Shift and click India's value in the 2024 column. This selects 25 cells.
  • Press Ctrl+C to copy.

Now paste the copied values vertically into the Analysis sheet.

  • Switch back to the Analysis sheet.
  • Click cell B2 (the first data cell under GDP Growth).
  • Right-click and select Paste Special.
  • In the Paste Special dialog, check the Transpose checkbox at the bottom.
  • Click OK.

What does Transpose do?

Transpose flips rows into columns and columns into rows. Your 25 horizontal cells (one row, many columns) become 25 vertical cells (many rows, one column). This is exactly what the Analysis table needs.

Column B should now show GDP growth percentages from 2000 to 2024. Repeat the same process for the other two indicators.

  • Click the Inflation sheet tab.
  • Find India's row (Country Code = IND) and select the values for years 2000 through 2024.
  • Press Ctrl+C to copy.
  • Switch to the Analysis sheet and click cell C2.
  • Right-click, select Paste Special, check Transpose, and click OK.
  • Click the GDP_PerCapita sheet tab.
  • Find India's row (Country Code = IND) and select the values for years 2000 through 2024.
  • Press Ctrl+C to copy.
  • Switch to the Analysis sheet and click cell D2.
  • Right-click, select Paste Special, check Transpose, and click OK.

Your Analysis table should now have numbers in all four columns for each year from 2000 to 2024.

Seeing errors or misaligned data?

If values ended up in the wrong cells, make sure you clicked the correct starting cell (B2, C2, or D2) before pasting. Undo with Ctrl+Z and try again.

If you see fewer than 25 values, double-check that you selected all the way from the 2000 column to the 2024 column on the raw sheet before copying.

Help me troubleshoot my Paste Special > Transpose results.

Handle missing values and format the data

Real-world datasets often have gaps. Before building formulas on top of this table, check for any blank cells and apply consistent number formatting.

  • On the Analysis sheet, scroll through columns B, C, and D looking for any blank cells.
  • If a year has no data from the World Bank, leave the cell blank. This is normal for very recent years where data has not been published yet.

Now format the GDP Growth and Inflation columns to display consistently.

  • Select the GDP Growth column values (B2:B26).
  • Hold Ctrl and also select the Inflation column values (C2:C26). Both ranges are now highlighted.
  • Right-click the selection and choose Format Cells.
  • In the Format Cells dialog, select the Number tab.
  • Choose Number from the Category list.
  • Set Decimal places to 1 and click OK.

Now format the GDP Per Capita column as currency.

  • Select the GDP Per Capita column values (D2:D26).
  • Right-click and choose Format Cells.
  • Under Category, choose Currency.
  • Set the symbol to $ (US Dollar) and Decimal places to 0.
  • Click OK.

Your Analysis sheet should now display clean, consistently formatted numbers. Column B shows values like 3.8, column C shows values like 4.0, and column D shows values like $443.

Why format matters for analysis

Consistent formatting prevents errors later. If some cells display 3.841 and others show 3.8, it becomes harder to spot patterns visually. Formatting also makes your dashboard look polished when you share it.

Seeing hash symbols (###) in cells?

Hash symbols mean the column is too narrow to display the formatted number. Double-click the column border in the header row to auto-fit the width.

Help me fix formatting issues in my Excel Table.

Your data is now clean, structured, and ready for analysis. In the next step, you will build formulas that categorize each year's growth and calculate how GDP compares against inflation.

Build Formulas for Insights

Your Analysis sheet now has a clean table with 25 years of India's economic data ready to go. In this step, you will turn those raw numbers into meaningful insights using formulas.

Formulas let you categorize, compare, and calculate new values from existing data without touching the original numbers. By the end of this step, your table will tell you which years were boom years, whether growth actually outpaced inflation, and how to group data for summarization.

In this step, get ready to:
  • Add an IFS formula to categorize each year's GDP growth level.
  • Calculate real GDP growth and year-over-year inflation change using XLOOKUP.
  • Add a Decade column to group years for Pivot Table analysis.
Categorize growth years with IFS

Not all growth years are equal. A year with 9% GDP growth is very different from a year with 2% growth, but right now your table just shows raw numbers.

  • Click on cell E1 in your Analysis sheet.
  • Type Growth Category and press Enter.
  • Click on cell E2 and enter the following IFS formula:
=IFS([@[GDP Growth (%)]]>8,"High Growth",[@[GDP Growth (%)]]>5,"Moderate Growth",[@[GDP Growth (%)]]>0,"Low Growth",TRUE,"Contraction")
  • Press Enter to confirm the formula.

What does this formula do?

IFS checks multiple conditions in order and returns the value for the first condition that is true.

  • If GDP Growth is above 8%, the year is labelled "High Growth".
  • If it is above 5% (but not above 8%), it is "Moderate Growth".
  • If it is above 0% (but not above 5%), it is "Low Growth".
  • The final TRUE acts as a catch-all for anything 0% or below, labelling it "Contraction".

The [@[GDP Growth (%)]] syntax is a structured reference that points to the GDP Growth column in the same row. Because your data is in an Excel Table, the formula auto-fills down to all 25 rows.

You should see the entire column E fill with category labels like "High Growth" or "Moderate Growth" for each year.

Seeing a #NAME? or #VALUE! error?

  • Make sure you typed the column name exactly as GDP Growth (%) including the space and parentheses. The structured reference must match the header text precisely.
  • Confirm you are typing the formula inside the IndiaEconomy table (cell E2, not outside the table range). If the table did not auto-expand, click inside the table, then go to Table Design > Resize Table and extend the range to include column E.
  • Check that your Excel is Microsoft 365. The IFS function is not available in older versions like Excel 2016.

help me fix the IFS formula error in my Excel table

Calculate real growth and inflation change

GDP growth alone does not tell the full story. If prices rise faster than the economy grows, people are not actually better off.

  • Click on cell F1 and type Real GDP Growth (adjusted).
  • Press Enter, then in cell F2 enter this formula:
=[@[GDP Growth (%)]]-[@[Inflation (%)]]
  • Press Enter to confirm.

What does Real GDP Growth show?

This subtracts inflation from GDP growth. A positive value means the economy expanded faster than prices rose (real economic expansion). A negative value means inflation ate up all the growth.

Column F should now show a mix of positive and negative decimal values across the 25 years.

  • Now click on cell G1 and type Inflation Change.
  • Press Enter, then in cell G2 enter this formula that uses XLOOKUP:
=IF([@Year]=2000,"N/A",[@[Inflation (%)]]-XLOOKUP([@Year]-1,[Year],[Inflation (%)]))
  • Press Enter to confirm.

What does this formula do?

This calculates how much inflation changed compared to the previous year.

  • XLOOKUP finds the previous year's inflation by looking up [@Year]-1 in the Year column and returning the matching Inflation value.
  • The outer formula subtracts last year's inflation from this year's inflation to get the change.
  • The IF wrapper returns "N/A" for the year 2000 because there is no 1999 row to look back at.

Column G should show "N/A" in the first row and decimal values (positive or negative) for 2001 onward.

Getting #N/A in rows other than 2000?

  • Double check that your Year column (A) contains plain numbers (2000, 2001...) and not text. If the years are stored as text, XLOOKUP cannot match them numerically.
  • Make sure the column header in A1 is exactly Year with no extra spaces. The structured reference [Year] in the formula must match the header.

help me fix the XLOOKUP formula returning errors in my Inflation Change column

Group years by decade

Later in this project, you will build a Pivot Table to summarize performance by time period. A Decade column gives the Pivot Table a clean grouping field to work with.

  • Click on cell H1 and type Decade.
  • Press Enter, then in cell H2 enter this formula:
=IF([@Year]<2010,"2000s",IF([@Year]<2020,"2010s","2020s"))
  • Press Enter to confirm.

What does this formula do?

This nested IF checks the year value and assigns a decade label. Years before 2010 become "2000s", years before 2020 become "2010s", and everything else becomes "2020s".

Using a formula-based grouping column (instead of Pivot Table date grouping) is a transferable skill you can use in any spreadsheet tool.

Column H should show "2000s" for years 2000 to 2009, "2010s" for 2010 to 2019, and "2020s" for 2020 to 2024.

  • Press Ctrl+S to save your workbook.

✔️ Awesome, I've got everything!

Great. Make sure you have saved your workbook with all 8 columns visible in the IndiaEconomy table.

ⓧ I'd like to double check the full formulas

Here is a summary of all four new columns and their formulas. Verify that your table matches:

  • E1 header: Growth Category
  • E2 formula:
=IFS([@[GDP Growth (%)]]>8,"High Growth",[@[GDP Growth (%)]]>5,"Moderate Growth",[@[GDP Growth (%)]]>0,"Low Growth",TRUE,"Contraction")
  • F1 header: Real GDP Growth (adjusted)
  • F2 formula:
=[@[GDP Growth (%)]]-[@[Inflation (%)]]
  • G1 header: Inflation Change
  • G2 formula:
=IF([@Year]=2000,"N/A",[@[Inflation (%)]]-XLOOKUP([@Year]-1,[Year],[Inflation (%)]))
  • H1 header: Decade
  • H2 formula:
=IF([@Year]<2010,"2000s",IF([@Year]<2020,"2010s","2020s"))

Each formula should auto-fill down all 25 rows because your data is in an Excel Table.

Your table now tells a richer story. Next up, you will summarize these 25 years of insights into a compact Pivot Table that shows performance by decade at a glance.

Create Pivot Tables for Summary Analysis

Your Analysis table now has eight columns of structured data, including growth categories and decade groupings. The next step is to summarize all of this into a high-level view that shows India's economic performance at a glance.

A Pivot Table lets you take a large dataset and instantly group, count, and average it without writing complex formulas. You will build two Pivot Tables that condense 25 years of data into a few meaningful rows.

In this step, get ready to:
  • Build a Pivot Table summarizing India's average GDP growth, inflation, and GDP per capita by decade.
  • Add a second Pivot Table counting the number of years in each growth category.
  • Format both Pivot Tables for clear readability.
Build a Pivot Table summarizing by decade

Your first Pivot Table will group India's economic data into three decade buckets (2000s, 2010s, 2020s) and calculate the average for each indicator. This reveals whether India's economy accelerated or slowed over time.

  • Switch back to the Analysis sheet in your workbook.
  • Click anywhere inside the IndiaEconomy table.
  • Click the Insert tab in the ribbon.
  • Click PivotTable.
  • Select From Table/Range if prompted.

A dialog box appears asking where to place the Pivot Table.

  • Select New Worksheet.
  • Click OK.

Excel creates a new sheet with an empty Pivot Table and opens the PivotTable Fields pane on the right.

  • Right-click the new sheet tab at the bottom of the screen.
  • Select Rename and type Summary.
  • Press Enter to confirm.

Now you will drag fields into the Pivot Table to define how your data is grouped and summarized.

  • In the PivotTable Fields pane, drag Decade to the Rows area.
  • Drag GDP Growth (%) to the Values area.
  • Click the dropdown arrow on Sum of GDP Growth (%) in the Values area.
  • Select Value Field Settings.
  • Change the summarization from Sum to Average and click OK.
  • Drag Inflation (%) to the Values area.
  • Repeat the same steps to change its summarization to Average.
  • Drag GDP Per Capita (US$) to the Values area.
  • Change its summarization to Average as well.

What does this Pivot Table show?

Each row represents a decade (2000s, 2010s, 2020s). The values show the average GDP growth rate, average inflation, and average GDP per capita for that period.

This instantly reveals trends. You can see whether growth accelerated or slowed across decades without scanning 25 individual rows.

Your Pivot Table should now show three rows with average values for each decade.

Seeing Sum instead of Average?

Make sure you clicked the dropdown arrow on each field in the Values area (not the Rows area) and selected Value Field Settings. The default is Sum, so each field needs to be changed individually.

If the PivotTable Fields pane closed, click anywhere inside the Pivot Table to reopen it.

help me fix my Pivot Table value settings

Add a second Pivot Table for Growth Category counts

Your second Pivot Table will count how many years fell into each growth category. This gives a quick picture of how often India experienced high growth versus contractions.

  • Click cell F1 on the Summary sheet to position the second table next to the first.
  • Click the Insert tab.
  • Click PivotTable and select From Table/Range.
  • In the Table/Range field, confirm it shows IndiaEconomy.
  • Select Existing Worksheet this time.
  • In the Location field, click cell F1 on the Summary sheet (or type Summary!$F$1).
  • Click OK.

A second empty Pivot Table appears starting at cell F1.

  • In the PivotTable Fields pane, drag Growth Category to the Rows area.
  • Drag Year to the Values area.

Why does Year show as Count?

When you drag a text or date field to Values, Excel defaults to Count. This is exactly what you want here. It counts how many years fell into each growth category (High Growth, Moderate Growth, Low Growth, Contraction).

You should now see rows like High Growth, Moderate Growth, Low Growth, and possibly Contraction, each with a count of years.

Second Pivot Table overlapping the first?

If you placed the second Pivot Table too close to the first, Excel may show a warning about overlapping. Click Undo (Ctrl+Z) and try again, this time clicking a cell further to the right (like F1 or G1) before inserting.

help me fix overlapping Pivot Tables in Excel

Format the Pivot Tables

Formatting makes your Pivot Tables easier to read and more presentable for stakeholders.

  • Click anywhere inside the first Pivot Table (the one starting at A1).
  • Click the PivotTable Design tab in the ribbon.
  • In the PivotTable Styles gallery, choose a medium blue or green style.

Now format the number columns for readability.

  • Select the cells showing Average GDP Growth values in the first Pivot Table.
  • Right-click and select Format Cells.
  • Choose Number with 1 decimal place and click OK.
  • Repeat for the Average Inflation column (Number, 1 decimal place).
  • Select the Average GDP Per Capita values.
  • Right-click, select Format Cells, choose Currency with the $ symbol and 0 decimal places.
  • Click OK.

What should I see?

Your first Pivot Table should display three rows (2000s, 2010s, 2020s). The average GDP growth for the 2000s should be higher than the 2010s, reflecting India's rapid expansion in that decade.

The second Pivot Table should show counts for each growth category. You will likely see most years classified as Moderate Growth or High Growth, with fewer years in Low Growth or Contraction.

  • Save your workbook by pressing Ctrl+S.

Numbers not formatting correctly?

Pivot Table cells sometimes resist formatting. Try selecting only the data cells (not the header row) and applying Format Cells again. If the formatting reverts after refreshing the Pivot Table, right-click a value cell, choose Value Field Settings, click Number Format, and set the format there instead.

help me format numbers in my Pivot Table

Your data is now summarized into clean, scannable tables. Next, you will turn these numbers into visual charts and build a dashboard that tells India's economic story at a glance.

Build a Visual Dashboard

Your Pivot Tables now summarize India's economic story by decade. Numbers in a table are great for precision, but charts let you spot trends and outliers at a glance.

In this step, you'll build a visual dashboard with line charts and conditional formatting. By the end, anyone looking at your workbook will immediately see India's growth trajectory, the 2020 COVID dip, and which years were boom years.

In this step, get ready to:
  • Create a line chart comparing GDP growth and inflation trends.
  • Build an area chart showing GDP per capita growth over time.
  • Apply conditional formatting to color-code economic performance.
Create a line chart for GDP growth and inflation

A line chart is ideal for comparing two metrics over time. You'll plot GDP Growth and Inflation side by side so viewers can see how the two measures move in relation to each other.

  • Right-click any sheet tab at the bottom of your workbook.
  • Click Insert to add a new sheet.
  • Double-click the new sheet tab and rename it to Dashboard.

Now switch to your Analysis sheet to select the data for your chart.

  • Click the Analysis sheet tab.
  • Select cells A1:A26 (the Year column including the header).
  • Hold Ctrl and also select cells B1:B26 (GDP Growth) and C1:C26 (Inflation).
  • Click the Insert tab in the ribbon.
  • In the Charts group, click the Line Chart dropdown.
  • Select Line with Markers (the option with dots on each data point).

A chart appears on your Analysis sheet. You need to move it to the Dashboard sheet.

  • Right-click anywhere on the chart border.
  • Click Move Chart.
  • Select Object in and choose Dashboard from the dropdown.
  • Click OK.

Excel automatically switches you to the Dashboard sheet with the chart. Now format the chart with a clear title and axis labels.

  • Click the chart title text at the top of the chart.
  • Replace it with India: GDP Growth vs Inflation (2000-2024).
  • Click the + icon that appears next to the chart (Chart Elements button).
  • Check the box next to Axis Titles.
  • Click the vertical axis title on the left side of the chart and type Percentage (%).
  • Delete the horizontal axis title (click it, then press Delete) since the year labels are self-explanatory.

What does this chart show?

The two lines let you compare how GDP growth and inflation track together over 25 years. Look for the dramatic dip in 2020 (the COVID contraction) and notice how inflation often spikes when growth slows.

Chart showing wrong data or extra lines?

If your chart has more than two lines, you likely selected extra columns when highlighting data. Delete the chart, reselect only columns A, B, and C (using Ctrl to select non-adjacent columns), and insert a new line chart.

If your chart shows years as a data series instead of the X-axis, right-click the chart and click Select Data. Make sure the Year column is set as the horizontal axis labels.

Help me fix my line chart data selection

Create a GDP per capita area chart

An area chart fills the space below the line, making it easy to see the overall magnitude of growth. GDP per capita rising steadily means the average Indian's income is growing year over year.

  • Click the Analysis sheet tab to switch back to your data.
  • Select cells A1:A26 (Year column).
  • Hold Ctrl and also select cells D1:D26 (GDP Per Capita column).
  • Click the Insert tab in the ribbon.
  • Click the Area Chart dropdown in the Charts group.
  • Select the first 2-D Area option.

Move this chart to the Dashboard sheet, just like you did with the first chart.

  • Right-click the chart border and click Move Chart.
  • Select Object in and choose Dashboard.
  • Click OK.
  • Drag the area chart below the line chart so both are visible without overlapping.
  • Click the chart title and replace it with India: GDP Per Capita Growth (2000-2024).

Your Dashboard sheet should now have two charts stacked vertically. The line chart shows percentage-based trends at the top. The area chart shows the rising income curve below it.

What should I see?

The GDP Per Capita area chart should show a steady upward curve that accelerates after 2014. The filled area makes the overall magnitude of growth feel tangible compared to a plain line.

Area chart looks flat or shows no data?

If the area is completely flat at zero, you may have selected column B or C (percentage values) instead of column D (GDP Per Capita in US$). Delete the chart, reselect columns A and D specifically, and try again.

Help me fix my area chart

Add conditional formatting to the Analysis table

Conditional formatting automatically colors cells based on their values. You'll use it to make high-growth years pop in green and contraction years stand out in red, directly in your data table.

  • Click the Analysis sheet tab.
  • Select the GDP Growth column values: cells B2:B26.
  • Click the Home tab in the ribbon.
  • Click Conditional Formatting in the Styles group.
  • Hover over Color Scales.
  • Select the Green - Yellow - Red option (green for highest values, red for lowest).

Your GDP Growth column now has a gradient. High-growth years like 2010 show green. Low or negative values show red. Next, add text-based rules to the Growth Category column.

  • Select the Growth Category column values: cells E2:E26.
  • Click Conditional Formatting in the Home tab.
  • Click Highlight Cells Rules, then Text that Contains.
  • Type Contraction in the text field.
  • In the format dropdown on the right, select a format with red fill (e.g. Light Red Fill with Dark Red Text).
  • Click OK.

Now add a second rule for high-growth years.

  • With E2:E26 still selected, click Conditional Formatting again.
  • Click Highlight Cells Rules, then Text that Contains.
  • Type High Growth in the text field.
  • In the format dropdown, select a format with green fill (e.g. Green Fill with Dark Green Text).
  • Click OK.

What does conditional formatting do here?

The color scale on column B gives you a heat map effect. High GDP growth years glow green. Contraction years glow red. You can scan 25 years of data and instantly spot the best and worst years.

The text-based rules on column E make category labels visually meaningful. Instead of reading each cell, the colors tell the story at a glance.

Check your Analysis sheet. The GDP Growth column should show a gradient from green (high values) to red (low values). The Growth Category column should have red-highlighted cells for any year labeled "Contraction" and green-highlighted cells for "High Growth" years.

Conditional formatting not showing colors?

Make sure you selected the data cells (B2:B26 or E2:E26) and not the header row. The header text won't trigger number-based color scales.

If the text rule for "Contraction" isn't highlighting anything, confirm that your IFS formula in Step 3 actually produced the word "Contraction" in column E. Check for extra spaces or different capitalization.

Help me troubleshoot conditional formatting

Switch to your Dashboard sheet one more time. You should see two charts telling India's economic story visually. The GDP Growth vs Inflation chart shows the 2020 COVID dip clearly. The GDP Per Capita chart shows a steady upward curve.

Secret mission

Compare India vs China

India's growth story is impressive on its own. But how does it compare to the world's other emerging giant? In this secret mission, you will download China's GDP growth data from the World Bank and build a side-by-side comparison chart that tells the story of two economic superpowers racing for growth.

Clean Up Your Resources

Clean Up Your Resources

This project runs entirely on your local machine using files you downloaded from the World Bank. There are no cloud resources, subscriptions, or accounts to manage.

Resources you used:

  • Excel workbook (local file, free, no ongoing cost).
  • World Bank CSV downloads (local files, free, no account needed).

Keep everything running

No action needed. Choose this if you want to keep your workbook as a portfolio piece or continue refining your dashboard.

  • Save your Excel workbook to a safe location (e.g. a Documents or Portfolio folder).
  • Keep the downloaded CSV files if you plan to re-import or reference the raw data later.
  • Everything is local on your machine. No cloud resources are running and nothing is costing you money.

Pause - I'll come back to this later

Since everything is local, there is nothing to pause. Your files stay on your machine until you decide to delete them.

  • Save and close your Excel workbook.
  • Your workbook and CSV files will be right where you left them when you return.

Delete - I don't want to use this again

Remove all project files from your machine. This is permanent.

  • Close Excel if it is still open.
  • Navigate to the folder where you saved your Excel workbook and delete the workbook file.
  • Navigate to your Downloads folder (or wherever you saved the World Bank CSV files) and delete all three India CSV files plus the China GDP Growth CSV file.
  • Empty your Recycle Bin (Windows) to permanently free the disk space.

Nice Work!

Nice Work!

You just turned raw World Bank CSVs into a professional economic analysis dashboard in Excel. That is exactly the kind of work data analysts do every day.

Here's what you accomplished:

  • Imported real economic data from the World Bank, cleaned messy CSV files, and structured them into a formatted Excel Table with XLOOKUP and IFS formulas for cross-referencing and categorization.
  • Created Pivot Tables summarizing India's economic performance by decade and growth category.
  • Built a visual dashboard with line charts, area charts, and conditional formatting that tells India's economic story from 2000 to 2024.
  • Secret Mission: Added China's GDP growth data and built a head-to-head comparison chart showing both countries' trajectories side by side.

Ready to quiz yourself?