How do you decide which kind of chart to use for a particular piece of data?

What the interviewer is looking for

• This question tests visualisation & dashboards. Matches chart types to the question, keeps dashboards focused on decisions, and mentions tools like Power BI, Tableau or Looker.
• Strong answers: Lines for trends, bars for comparisons, careful use of pie charts, and choosing based on the question the viewer needs answered.
• Likely follow-up: What's a chart you see often that you think is usually a bad choice?

Another way it may be asked: You need to show monthly revenue for three years and also the share of revenue by product. Which charts would you use and why?

A structure to follow: Answer, explain, example, limits

1. Step 1

   Answer

   Give your direct answer in the first sentence so the interviewer knows where you are going.

2. Step 2

   Explain

   Say how it works or why you would do it that way, in plain words before jargon.

3. Step 3

   Example

   Anchor it in something you have actually done or seen, with the detail that shows hands-on experience.

4. Step 4

   Limits

   Say when your approach would not be the right one. It shows judgement.

This is guidance on shape, not a script. Use your own real experience and facts; never invent details to fill a gap. See the STAR guide and answer frameworks.

Common slips

• Reciting a definition without showing you have applied it.
• Using terms you cannot explain if asked a level deeper.
• Claiming experience beyond what you can discuss in detail.

How to practise it

Say the answer in 90 seconds, then answer the follow-up as if it were a new question.

Related questions

• How do you design a dashboard that executives will actually use, rather than one that gets ignored after a month?
• What's the difference between an inner join and a left join, and when could picking the wrong one give you misleading numbers?
• You're handed a spreadsheet of sales with duplicate rows, mixed date formats and some blank regions. How would you clean it up?
• Weekly sign-ups dropped fifteen percent last week. Walk me through how you'd figure out why.
• If you were asked to define the key metrics for a subscription business, which would you choose and why?

Browse all questions