Shopping

A six-month price chart for rice, dal and oil in Excel

Make a six-month price chart for rice, dal and oil in Excel: set up the table, insert a line chart, and fix the scale so all three lines are readable.

Editorial illustration for A six-month price chart for rice, dal and oil in Excel

To chart grocery prices over six months in Excel, make a table with one row per monthly shop and one column per staple, select it, and insert a line chart with markers. Because rice, dal and oil sit at very different price levels, convert each to an index starting at 100, or put one on a secondary axis. A chart like this shows which staple is drifting up, using your own numbers.

What do you record each month?

On your regular monthly shop, note the per-kg price of rice and dal and the per-litre price of oil, from the bill. Keep the same brand and pack size every time, or the numbers will not be comparable. If you buy different brands, log the one you use most.

The figures below are invented for illustration, not real market prices.

MonthRice per kgDal per kgOil per litre
June₹58₹160₹128
July₹59₹164₹130
August₹59₹170₹133
September₹61₹168₹131
October₹60₹172₹135
November₹62₹175₹138

How do you insert the chart?

  1. Type the table in cells A1 to D7, with the headings in row 1. Enter months as text, and prices as plain numbers.
  2. Select A1 to D7.
  3. On the Insert tab, in the Charts group, click Insert Line or Area Chart and pick Line with Markers.
  4. Excel plots the three columns as three lines, with the months along the bottom.
  5. With the chart selected, use Chart Design, then Add Chart Element, to add a chart title and axis titles, such as Price in rupees.

The menu names can vary a little between Excel versions, but the steps are the same.

Why do the lines look flat or squashed?

Rice sits around ₹60 and dal around ₹170, so on one axis from 0 to 180 all three lines look nearly flat and the movement is hard to read. There are two fixes.

Fix one: a secondary axis

Click the oil line, right-click, choose Format Data Series, and under Plot Series On select Secondary Axis. The oil line now has its own scale on the right.

Fix two: an index chart

Convert each staple to an index where the first month equals 100. In a second table, enter =B2/B$2*100 in the first row of the rice column and copy down and across. After six months, rice is at 62 ÷ 58 × 100, about 106.9. Dal is 175 ÷ 160 × 100, about 109.4, and oil is 138 ÷ 128 × 100, about 107.8. All three then start at 100, and the chart shows which one is rising fastest.

What do the made-up numbers say?

Over six months, rice rose ₹4 per kg, which is about 6.9%. Dal rose ₹15 per kg, about 9.4%, the biggest move. Oil rose ₹10 per litre, about 7.8%. If your household uses 5 kg of rice, 2 kg of dal and 3 litres of oil a month, the monthly basket went from 5 × ₹58 + 2 × ₹160 + 3 × ₹128 = ₹994 to 5 × ₹62 + 2 × ₹175 + 3 × ₹138 = ₹1,074, an increase of ₹80 a month.

How do you keep it going?

  • Enter the three prices on shopping day, from the bill, not from memory.
  • Extend the table and the chart range each month.
  • After twelve months, add a column for the same month last year.
  • If a price jumps, check the pack size before suspecting the price.

The bill totals belong in your expense tracker as well. If you upload statements or add grocery shops by hand in SpendixAI, a custom Groceries category lets you set the basket total beside the price lines you chart here, and you can see how much of any increase actually reached your monthly budget.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports