Pick the right chart for a month of your own spending

A chart is an answer to one question. You are testing that idea on your own month of spending: the same small table drawn three ways, and a clear judgement on which picture answers which question at a glance.

• What are the two questions you actually care about, written before you open the chart menu?
• Which five or six categories would make sense to you, not to a textbook?
• Does your second question need dates (a line through the month) or only totals (bars or a pie)?
• What would a chart that hides the answer look like for each question?

A neat table of one real month, grouped into a handful of categories, three labelled charts side by side, and a short note that says plainly which chart answers which question and which one fails, with a reason you can see in the picture.

Drawing the prettiest chart first and then inventing a question it answers. Write the two questions on top of the sheet before you draw anything, and judge every chart against them.

• One month of your own UPI history, wallet app or bank statement
• Cash spends you remember, added by hand and marked as from memory
• Your two written questions, kept at the top of the sheet

AI must not fill in spends, guess categories for payments you cannot recognise, or round your numbers into a nicer story. If you cannot tell what a payment was, put it in an 'unknown' category.

1. 3.1 Put the month into a clean tableGOOGLE SHEETS

   Why this tool: A sheet keeps every spend as a row so you can total by category and by week without retyping.

   Copy each spend as a row with date, amount and a short description. Add a category column and fill it yourself. Use a pivot table or a simple sum to get one total per category and one per week.

2. 3.2 Ask which chart suits each questionCLAUDE CHAT

   Why this tool: Talking it through helps you connect a question to a chart type before you draw.

   Describe only your questions and the shape of your table, not your amounts. Read the reasons, then decide yourself.

   Prompt to copy · fill in the [brackets]Copy

   I have a month of my spending in a table: [describe columns and number of categories]. My two questions are:
   1. [question one]
   2. [question two]
   For each question, which chart type would make the answer easy to see at a glance, and which chart type would hide it? Explain your reasoning in two lines each. Do not suggest any numbers.

3. 3.3 Draw all three charts yourselfGOOGLE SHEETS

   Why this tool: You only learn what a chart hides by drawing it and looking at it with your own eyes.

   Draw a pie and a bar from the category totals and a line from the weekly totals. Give each a title that states the question it tries to answer, and label units on every axis.

4. 3.4 Critique your noteCLAUDE CHAT

   Why this tool: A second reader spots claims your charts do not actually support.

   Write your note first, then ask Claude to check it against your chart descriptions.

   Prompt to copy · fill in the [brackets]Copy

   Here are my three charts described in words: [describe each chart]. Here is my note on which chart answers which question: [paste note]. Point out any claim in my note that the chart descriptions do not support, and any place where I judged a chart unfairly. Ask me questions rather than rewriting the note.

• The category totals add up to the month total in your raw table
• Each chart title names the question it tries to answer
• The chart you call 'hides the answer' really does: show it to a friend and ask them the question
• The line chart uses weeks in order, with no week missing
• Recompute two numbers by hand
• Check the row count before and after cleaning

AI often recommends a pie chart for 'where did my money go' without noticing that six slices of similar size are hard to compare. Trust what you see: if you cannot rank the slices quickly, the bar chart wins.

• One real month in a table, with an 'unknown' row if needed
• Two questions written above the charts
• Three charts, each titled and labelled
• A short note judging each chart against each question

One page: the questions at the top, the three charts in a row, the note underneath. Round or hide amounts if you plan to share it publicly.

Say which chart you expected to win and which one actually did, and what that taught you about choosing a chart for a manager's question.