Excel sorts months January to December by default, so a pivot table or chart for the Indian financial year starts in the wrong place. The most reliable fix is a helper column that turns each date into a fiscal month number, April = 1, and sorting on that. A custom list and a Power Query column are the alternatives.
Why does the pivot put January first?
When you group dates by month, Excel orders them by calendar month. April to March is an accounting choice, not something the pivot knows about. You have three ways to tell it, from simplest to most flexible.
How does the helper column method work?
Add two columns to your data. In column E, the fiscal month number:
=MOD(MONTH(A2)+8, 12)+1
April gives 1, December gives 9, January gives 10, March gives 12. In column F, a label that sorts as text:
=TEXT(E2,"00")&" "&TEXT(A2,"mmm")
That produces 01 Apr, 02 May, up to 12 Mar. Now build the pivot with column F in Rows. Because the labels start with a number, the standard A to Z sort runs in April to March order. In a chart, plot that same field.
Can you use a custom list instead?
Yes, if your month field is text such as Apr, May, Jun. In Excel go to File, Options, Advanced, General and choose Edit Custom Lists. Add the twelve months in April to March order. Then in the pivot, right-click the PivotTable, open PivotTable Options, go to the Totals and Filters tab, and make sure Use Custom Lists when sorting is ticked. Sort the field A to Z and the order follows your list.
This keeps the data clean, but the list lives on your copy of Excel. If you share the file, the other person may need to add the same list. The helper column travels with the workbook.
How do you do it in Power Query?
If your data already goes through Power Query, add a custom column with:
Number.Mod(Date.Month([Date]) + 8, 12) + 1
Name it FiscalMonth and set its type to Whole Number. If you load to the Data Model, open Power Pivot and set the month name column to Sort By FiscalMonth, and every pivot and chart that uses that name will follow.
Which method should you pick?
| Method | Good for | Watch out for |
|---|---|---|
| Helper column | Small workbooks, sharing, charts | Two extra columns to keep filled down |
| Custom list | Text month names, one-off reports | Stays on your computer, not in the file |
| Power Query | Data refreshed every month | Needs Excel with Power Query, a bit more setup |
What about Google Sheets?
Sheets pivot tables sort a row field by its own labels, so the helper label column does the job: add it to the data, use it as the Rows field and set the order to Ascending. 01 Apr to 12 Mar then appears in the right sequence. For a normal chart, sort the source range by the fiscal month number first.
How do you check the result?
- Add a row dated 1 April and one dated 31 March, refresh, and confirm April is first and March is last.
- Check that the grand total matches your data total, in case a blank date got excluded.
- Refresh the pivot after adding new rows, or convert the data to a table so ranges grow automatically.
What if a chart still starts in January?
Check which field the chart is built on. A chart created from a pivot follows the pivot's order, so fix the pivot first. A chart built straight from a range follows the order of the rows, so sort the range by the fiscal month number before you create it. If you had already made the chart, select it, choose Select Data and confirm that the axis labels point to the sorted label column and not to the original date column.
If you keep your expenses in SpendixAI instead of a hand-built sheet, a CSV download of the transactions drops straight into this same helper-column layout.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

