Pick the Right Excel or Google Sheets Chart for the Point You Want to Make

Get one recommended chart tied to your message, exact build steps for Excel or Google Sheets, a takeaway title, and one chart to avoid with the reason.

You getRecommended chart and why, data prep and build steps

Prompt

Prompt
Act as a data visualization specialist who builds charts in Excel and Google Sheets every day.

Your job: recommend the single best chart for my data and the point I want to make, then tell me exactly how to build it.

Before answering, ask me these questions in one message and wait for my reply:
1. What does your data look like? Paste a few rows with headers, or describe the columns.
2. What one point should the chart make (a trend, a comparison, a share of a total, a relationship)?
3. Who will see it, and where (slide, report, dashboard)?
4. Excel or Google Sheets?

Rules:
- Pick one chart and justify it by the message, not by the data shape alone.
- Give build steps as numbered actions using the real menu names in my tool, covering data range, sort order and axis settings.
- Write a chart title that states the takeaway as a full sentence, not a label.
- Give exactly 3 formatting changes, each removing clutter or adding focus.
- Name one chart to avoid for this data and the specific way it would hide or distort the point.

Output format:
1. Recommended chart and why (2 sentences)
2. Data prep (bullets)
3. Build steps (numbered)
4. Takeaway title
5. Formatting fixes (3 bullets)
6. Chart to avoid and why

End with one line on any assumption you made or missing detail that could change the recommendation.

Example output

At a glanceRecommended chart vs chart to avoidShowing West overtaking East in Q3, Google Sheets
ItemLine chart (use)Stacked column (avoid)
ShapeOne line per regionRegions stacked in one bar
West vs EastCompared directlyCannot compare directly
Crossover pointVisible at a glanceDisappears
West styling4px dark blue, September labelStarts at different height monthly

Example for: monthly sales for 4 regions (Jan–Dec), Google Sheets, showing leadership that West overtook East in Q3.

1. Recommended chart and why

A line chart with one line per region. Your point is a change in rank over time, and lines make the moment West crosses East visible at a glance.

2. Data prep
  • Put months in column A (Jan–Dec) and one region per column in B–E.
  • Order columns so East and West sit next to each other (B and C).
  • Make sure sales values are numbers, not text (no "$" typed into cells).
  • Remove any total row so it does not plot as a fifth line.
3. Build steps
  1. Select A1:E13.
  2. Click Insert > Chart.
  3. In Chart editor > Setup, set Chart type to Line chart.
  4. Confirm Use row 1 as headers and Use column A as labels are checked.
  5. Go to Customize > Vertical axis, set Min to 0 and Number format to Currency (rounded).
  6. Go to Customize > Series, select West, set Line thickness to 4px and color dark blue.
  7. Select East, set color orange, thickness 3px.
  8. Set North and South to light gray, thickness 1px.
  9. In Customize > Series > West, check Data labels and delete all but the September label.
4. Takeaway title

West passed East in September and led every month after.

5. Formatting fixes
  • Turn off gridlines except the horizontal major ones (Customize > Gridlines and ticks).
  • Move the legend to Top or remove it and label line ends directly with text boxes.
  • Shorten month labels to Jan, Feb, Mar to stop them rotating.
6. Chart to avoid and why

Stacked column chart. Stacking puts West on top of other regions, so its bar starts at a different height each month. Readers cannot compare West and East directly, and the crossover point disappears.

Assumption: all regions use the same currency and fiscal months; if one region had a partial year, flag it in a footnote.

Written by AI from this prompt. Your results will vary.

Tips and common edits

Why this works

  • Asking for the message first means the chart is chosen for what readers should conclude, not just the data's shape.
  • Requiring real menu names and numbered steps turns advice into something you can follow click by click.
  • Naming one chart to avoid, with the specific distortion, teaches the reasoning and prevents a common mistake.

Use before building a chart for a report, slide or dashboard. Have a few rows of your data and the one sentence you want readers to remember. Works in ChatGPT, Claude or Gemini.

Common edits

  • Ask for two alternative charts ranked against the recommendation.
  • Add 'for a colorblind audience' to get palette and labeling advice.

Prompt details

By
Prompts-GPT editors
Published

Did this prompt work?

Keep exploring

More in Excel & Spreadsheets