Decoding Bar and Line Graphs Quickly
Bar graphs show discrete comparisons; line graphs emphasise TREND over time. First read the axis scale and unit โ SBI PO loves dual-axis charts where one series is in Rs cr and another in %. For stacked/grouped bars, each segment is a separate value; total = sum of segments. For line charts, a STEEPER slope means a larger change, not a larger value. Common question types: difference between two bars, ratio of two points, average over a period, percentage growth between two years. Speed habit: estimate from the gridlines first to eliminate 2 distant options, then compute precisely only between the 2 close ones. Watch for 'between' (exclusive) vs 'from-to' (inclusive) in period questions.
Average and Difference Formulas for Charts
Bar graphs and line charts in SBI PO papers are not really tests of mathematics โ they are tests of formula discipline under time pressure. A typical DI set throws five questions in eight minutes, and the only thing standing between you and a clean +5 is the muscle memory of half a dozen averaging and difference formulas. Master them once, and DI becomes scoring territory.
Definition: The average (arithmetic mean) of n values is the sum of the values divided by n.
Definition: Percentage growth from a starting value to an ending value measures the change as a percentage of the starting value.
The Core Formulas, One by One
1. Average Over n Periods
Average = (sum of all values) / n.
If a line chart shows sales in 5 years โ say โน120, โน150, โน180, โน200, โน250 crore โ the average is (120 + 150 + 180 + 200 + 250) / 5 = 900 / 5 = โน180 crore. Read all five gridlines carefully, add, divide. Do not mentally "guess" the average from the shape of the line.
2. Required Value for a New Average
If you already have n values with a known sum and you want the (n+1)-th value to make a target average:
Required value = (new average ร new count) โ current sum.
Question: The average score of 5 students in a test is 72. What score must a 6th student get so that the average rises to 75?
Solution:
Step 1: Current sum = 5 ร 72 = 360.
Step 2: New total needed = 6 ร 75 = 450.
Step 3: Required value = 450 โ 360 = 90.
Conclusion: The 6th student must score 90.
This single formula handles dozens of DI variants โ "average rises by 2," "new candidate brings the average down by 1," "what was the missing year's value," and so on.
3. Percentage Growth Over Several Years
Across a multi-year line chart, percentage growth from year 1 to year N is:
% growth = (valueN โ value1) / value1 ร 100.
This is NOT the sum of the yearly growth percentages. Year-on-year percentages compound, they do not add. Three years of 10% growth each give an overall growth of 33.1%, not 30%. SBI PO regularly traps students with the "add the yearly percentages" mistake.
Question: A company's revenue rose from โน400 crore in 2018 to โน540 crore in 2022. What is the percentage growth over the period?
Solution:
Step 1: Difference = 540 โ 400 = 140.
Step 2: % growth = 140 / 400 ร 100 = 35%.
Conclusion: 35% growth over the period.
4. "Overall Ratio" Across Two Series
If you have two series (say "exports" and "imports") tracked over five years and the question asks for the overall ratio of exports to imports across all five years, do not average the yearly ratios. Instead:
- Sum the export figures.
- Sum the import figures.
- Divide.
Overall ratio = (ฮฃ exports) : (ฮฃ imports).
This is because the ratio is a weighted average, and only summing-then-dividing weights each year correctly.
5. CAGR Shortcut (Rare in Prelims)
CAGR โ Compound Annual Growth Rate โ is the constant rate at which a value would have grown each year to reach its final value:
CAGR = (Final/Initial)^(1/n) โ 1, where n is the number of years.
A handy shortcut: if a quantity doubles in n years, total growth is 100% and CAGR โ 72 / n % (the "Rule of 72"). For Prelims, plain percentage growth is usually enough โ CAGR shows up mostly in Mains-level questions on financial growth.
6. Difference Questions Across Years
For "by how much did X exceed Y in year Z," just subtract directly from the gridline readings:
Difference = (X reading) โ (Y reading).
Watch the units. If the y-axis says "โน in crore," report the answer in crore. If two series share the y-axis, you can read both off the same scale; if they have different y-axes (a left axis and a right axis), apply each scale separately.
7. The Mixed-Unit Trap (Bar + Line on One Chart)
This is SBI PO's favourite trap. A chart shows a bar for total revenue (in โน crore, absolute number) and a line for the percentage of revenue coming from a single product, year by year. To get the actual revenue of that product in any year:
Actual value of the % series = (% reading) ร (corresponding total).
Question: In 2022, total revenue = โน800 crore (bar reading). The line shows that 35% came from product A. What was the absolute revenue of product A in 2022?
Solution:
Step 1: Identify the bar value: โน800 crore.
Step 2: Identify the line value: 35%.
Step 3: Actual = 35% ร 800 = 0.35 ร 800 = โน280 crore.
Conclusion: โน280 crore.
If you forget this multiplication and just compare percentages across years, you can get the entire question set wrong.
Why It Matters
Why it matters: DI carries 30โ35 marks out of 60 in SBI PO Prelims's Quant section and around 50 marks in Mains. Barโline combinations and "with percentage" charts are the most common chart formats. Mastering the seven formulas above can give you a 90%+ accuracy at full speed โ and DI is where toppers separate themselves from the pack.
Real-World Example
Real-world example: When the RBI publishes the Annual Report, it shows a bar for total agricultural credit each year and a line for the share of small and marginal farmers in it. To answer "by how much did credit to small farmers rise from 2018 to 2023," you would multiply each year's bar by the corresponding line's % and then subtract. The trick is exactly the SBI PO "mixed-unit" formula.
Common Misconception
Common misconception: Many candidates add the yearly percentage growth figures across a multi-year span: "5% + 8% + 12% = 25%." This is wrong because percentages of different base values cannot be added. Always use (final โ initial)/initial ร 100 over the whole stretch.
Another slip: averaging ratios. If the export-to-import ratios over three years are 2:3, 3:4 and 4:5, the overall ratio is not the average of these ratios. Sum the exports, sum the imports, then take the ratio.
A third slip: forgetting which series the question is about. Highlight the relevant series with a thumbnail symbol on the rough sheet before computing.
Speed Tactics
When the timer is ticking, the order of operations matters. Read the question stem first, then look only at the data you need. If three years are mentioned in the stem, ignore the remaining four. Use approximation where the options are widely spaced โ for example, 35% of 783 โ 35% of 800 = 280, and if the nearest options are 240 and 290 you have your answer without exact arithmetic.
| Need | Wrong shortcut | Correct formula |
|---|---|---|
| Average over n years | Eyeball the middle of the line | Sum / n |
| Value needed for new average | Just add the new value | (new avg ร new count) โ current sum |
| Multi-year % growth | Sum of yearly %s | (final โ initial) / initial ร 100 |
| Overall ratio of two series | Average the yearly ratios | Sum each series, then divide |
| Actual value when % line + total bar | Use only the % reading | % ร corresponding total |
- โ- Average = sum / n; required value to hit a target average = (new avg ร new count) โ current sum.
- โ- Percentage growth over a span is computed from the start and end values, NOT by adding yearly percentages.
- โ- For an overall ratio across years, sum each series first, then divide โ never average the ratios.
- โ- CAGR uses the n-th root formula; the Rule of 72 estimates doubling time.
- โ- For mixed bar-and-line charts where one is absolute and one is %, multiply % by the matching absolute value.
- โ- Read questions before reading data; pick only the years and series you need.
- โ- Approximation and option-elimination beat exact arithmetic when time is short.
"Sum, Divide, Done" โ for averages. "Final minus Initial, over Initial" โ for % growth. "Bar times Line" โ whenever one series is a percentage of another.
- โ- Six core formulas cover almost every bar/line DI question in SBI PO.
- โ- Percentages of different bases never add; ratios across years never average.
- โ- For combined charts, the % series is meaningless without the matching absolute total.
- โ- Speed comes from formula reflex + approximation + option elimination, not from heavy arithmetic.
Worked Example: Dual-Series Line Chart
Dual-series line charts look harmless on the screen, but in the SBI PO data interpretation section they decide who finishes the set in two minutes and who burns five. The single habit that separates the two groups is simple: never read profit; always compute it once, write it down, then read it.
Definition: A dual-series line chart is a graph with two lines drawn on the same axes โ here, one for Revenue and one for Expenditure โ across the same time periods (years). The vertical gap between the two lines at any year is the Profit for that year.
Definition: Profit in DI is simply Revenue minus Expenditure. If Expenditure is larger than Revenue, the result is a Loss (a negative profit). All "profit growth", "profit ratio", "average profit" and "highest profit year" questions ultimately read from a single derived row: profit per year.
Reading the chart the smart way
Most aspirants make one expensive mistake: they treat each sub-question as a fresh problem and re-read the chart from scratch. The chart in this lesson plots Revenue and Expenditure (in Rs crore) for four years โ 2021, 2022, 2023, 2024. Before solving anything, build a tiny mental table.
For 2021, Revenue = 120 and Expenditure = 90, so Profit = 30. For 2022, Revenue = 150 and Expenditure = 100, so Profit = 50. Once you have written "30, 50, โฆ" above each year's point on the rough sheet, every question downstream becomes a lookup, not a calculation. This is the same idea as memoising a function โ pay once, reuse many times.
The two question types you must separate
SBI PO setters love to interleave two superficially similar percentage questions, and students confuse them under stress.
Type A โ Percentage change in profit between two years. The base is the earlier year's profit. From 2021 to 2022, profit grew from 30 to 50, so the percentage increase = (50 โ 30)/30 ร 100 = 20/30 ร 100 = 66.67%. Notice the base: it is 30 (the previous year), not 50 and not the revenue.
Type B โ Profit as a percentage of revenue (profit margin) in a single year. The base is that year's revenue. For 2022, profit margin = 50/150 ร 100 = 33.33%. The base is revenue, not the previous profit.
Why it matters: One careless swap of base โ using revenue when the question wants previous profit, or vice versa โ is enough to land on a wrong option that the setter has deliberately placed in the answer choices as a trap.
Why pre-computing profit saves the set
Real-world example: Think of an SBI branch manager getting monthly numbers from head office. She does not recompute "what was March's profit?" every time someone asks; she keeps a one-line summary above each month. That is exactly the discipline an SBI PO aspirant must build in the DI section. With profit pre-computed:
- "Average profit over the four years" โ just add the four numbers and divide by 4.
- "Year with highest profit" โ glance at the row.
- "Ratio of profit in 2023 to 2024" โ write the two numbers directly.
Each of these would otherwise demand reading two points off the chart and subtracting โ about 8โ10 seconds saved per sub-question, which is huge when a single caselet has 5 sub-questions.
Common misconception: "If revenue rises, profit must rise." Wrong. Profit depends on the gap between the two lines, not on either line alone. A year with higher revenue can have lower profit if expenditure rose faster. Always look at the vertical gap, never at one line in isolation.
Question: From the chart, Revenue in 2021 = 120 and 2022 = 150 (Rs cr), Expenditure in 2021 = 90 and 2022 = 100 (Rs cr). Find (a) the percentage increase in profit from 2021 to 2022 and (b) the profit as a percentage of revenue in 2022.
Solution:
Step 1: Compute profit for each year. Profit 2021 = 120 โ 90 = 30. Profit 2022 = 150 โ 100 = 50.
Step 2: For (a), the base is profit of 2021. Percentage increase = (50 โ 30)/30 ร 100.
Step 3: 20/30 = 2/3 = 0.6667, so the answer is 66.67%.
Step 4: For (b), the base is revenue of 2022 = 150. Profit margin = 50/150 ร 100.
Step 5: 50/150 = 1/3 = 0.3333, so the answer is 33.33%.
Conclusion: (a) 66.67% increase in profit; (b) 33.33% profit margin in 2022. Different bases, very different answers โ that is the entire point of the lesson.
| Quantity asked | Formula | Base (denominator) | 2022 value |
|---|---|---|---|
| Profit | Revenue โ Expenditure | โ | 50 |
| % change in profit (2021โ2022) | (Pโ โ Pโ)/Pโ ร 100 | Previous year profit (30) | 66.67% |
| Profit margin in 2022 | Profit / Revenue ร 100 | Same-year revenue (150) | 33.33% |
| Expenditure as % of revenue | Expenditure / Revenue ร 100 | Same-year revenue (150) | 66.67% |
- โ- Profit at each point = vertical gap between Revenue and Expenditure lines.
- โ- Compute profit for every year once, write it above the chart โ never recompute.
- โ- "% increase in profit" โ base is previous year's profit.
- โ- "Profit margin" โ base is same year's revenue.
- โ- A rising revenue line does not guarantee rising profit; watch the gap.
- โ- Loss appears when the Expenditure line crosses above Revenue.
- โ- "Highest profit year" need not be the highest revenue year.
- โ- Ratios of profits cancel units; do not bother converting Rs cr.
G-P-M for dual-line charts: Gap gives profit, Previous profit is the base for change, Margin uses same-year revenue as the base. Whisper "G-P-M" before every DI caselet on line charts.
- โ- Dual-series line chart = two quantities, one axis; the vertical gap is the story.
- โ- Pre-compute profit per year before reading any sub-question.
- โ- Pick the right base โ previous profit for change, same-year revenue for margin.
- โ- One pass of arithmetic, many sub-questions answered.
Bar Graphs and Line Charts โ Flashcards
Cover the answer, recall, then check. 12 cards on reading bar and line charts in SBI PO DI.
Q1. In a stacked bar, how do you read a middle segment's value?
A1. Top reading of the segment โ its bottom boundary. Never read the top of a segment as its value.
Q2. First step with any grouped (multi) bar chart?
A2. Match each bar to its legend colour/pattern before computing โ mismatches are the top error.
Q3. What does a steeper upward slope on a line chart mean?
A3. A larger ABSOLUTE increase between those two points โ not necessarily a larger percentage increase.
Q4. Percentage increase from 250 to 300?
A4. (300 โ 250)/250 = 50/250 = 20%.
Q5. In a year, Y = 240 and X = 300. Y as a percent of X?
A5. 240/300 = 80%.
Q6. Average of X over three years: 200, 250, 300?
A6. (200 + 250 + 300)/3 = 750/3 = 250.
Q7. To find the year of highest percentage growth, what do you compare?
A7. Successive ratios New/Old โ the largest ratio is the largest % growth (not the largest raw gap).
Q8. Bigger increase: +50 on a base of 500, or +30 on a base of 100?
A8. +30 on 100 = 30% beats +50 on 500 = 10%. Percentage, not absolute, decides "bigger increase".
Q9. In a double-line chart, how do you get the gap between two products in a year?
A9. Subtract the two y-axis readings at that x-position.
Q10. How do you read a value that falls between gridlines?
A10. Estimate in halves/quarters of a gridline; DI values are almost always "nice" round numbers.
Q11. Top error specific to grouped bars?
A11. Mixing up which coloured bar in the cluster belongs to which category/year.
Q12. How do you get a product's total across all years?
A12. Sum that product's bar heights (or line points) across every year.
Bar Graphs and Line Charts โ Summary
Bar graphs and line charts are the most frequent visual DI in SBI PO. In the Mains 35-question Data Analysis section expect at least one multi-bar or double-line set, and Prelims usually carries a simple bar or line DI too. The underlying data is identical to a table โ the challenge is reading values off the axes quickly and not misreading grouped or stacked bars.
Reading the chart
- Single bar: height = value; read it against the y-axis gridlines.
- Grouped bar: each cluster has 2โ3 bars (e.g. 2021 vs 2022) โ match every bar to the legend colour.
- Stacked bar: one bar split into segments; a segment's value = its top reading minus its bottom reading.
- Line chart: slope shows the trend; a rising segment means growth, and a steeper slope means a larger absolute change.
Core math (same as tables)
- % change between two points = (later โ earlier)/earlier ร 100.
- Ratios and averages across categories work exactly as in tabular DI.
| Year | Product X (units) | Product Y (units) |
|---|---|---|
| 2020 | 200 | 150 |
| 2021 | 250 | 180 |
| 2022 | 300 | 240 |
Example: X's growth 2020 to 2022 = (300 โ 200)/200 = 50%. In 2022, Y is 240/300 = 80% of X. The 2021 combined total = 250 + 180 = 430.
Exam Tricks & Tips
- ๐ฏ For stacked bars, always subtract the lower boundary โ never read the top of a segment as its value.
- ๐ฏ Match every bar to its legend colour before computing; grouped-bar mismatches are the top error.
- ๐ฏ Steepest line = largest absolute change, but for % change you still need the base โ a steep line off a big base can be a small percentage.
- ๐ฏ Estimate between gridlines in halves/quarters; exact values are almost always round numbers.
- ๐ฏ For "which year had the highest growth", compare successive ratios, not raw gaps.
- โ Don't confuse absolute increase with percentage increase โ +50 on a base of 500 (10%) is smaller than +30 on 100 (30%).
Expected exam pattern
A double bar or double line over 4โ6 years. Asks include percentage growth, the ratio of two products in one year, a product's average over all years, and "in which year was the increase (or percentage increase) the greatest".
Quick recap
Read stacked segments by subtraction, match colours to the legend, use the earlier value as the base for % change, and keep absolute change separate from percentage change.