Prompt Almanac

Create intermediate Works with: Any AI

PowerPoint Chart Slides From Excel Data With Message Titles

Structured brief Has example

Turn a table of numbers into clear chart slides.

Open in ChatGPTOpen in Claude

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.

Rate this prompt

Loading ratings…

Help me make chart slides in PowerPoint from Excel data. Data (columns and rows): [DATA]. Decision or message for the audience: [MESSAGE]. Audience: [AUDIENCE]. Number of slides allowed: [SLIDE_LIMIT].

For each slide give a template: a title sentence stating the finding, the chart, a one-line takeaway and a source line. Propose the chart type and why, what to highlight and what to grey out, labels and units, and keep chart colours consistent across the deck. Calculate the numbers used in titles and show the arithmetic; for example, Q1 sales of 480 and Q2 sales of 540 is a change of 60, which is 60 / 480 = 12.5 percent. Use only the numbers I gave, and say what to leave out of the deck and put in an appendix.

Explain the choice between pasting a picture, embedding a chart and linking to the Excel file, with the risk of each (broken links, hidden data, file size, stale numbers) [VERIFY], and recommend one. Checks: numbers on the slide match the workbook, bar axes start at zero, and the chart is legible from the back of the room.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

See an example result (fictional data)
Invented data: Q1 sales 480, Q2 sales 540. Change = 540 - 480 = 60; percentage = 60 / 480 = 12.5 percent.
Slide title: "Sales grew 12.5 percent from Q1 to Q2". Chart: column chart, Q2 highlighted, Q1 grey, axis starting at zero. Source line: Finance workbook, March export. Second slide: Q2 sales by region: North 240, South 180, West 120; total 540. Title: 'The North produced 44 percent of Q2 sales' (240 / 540 = 44.4 percent). Chart: sorted bars with the North highlighted. Appendix slide: the full table with the source and date. Check: the three regions add to 540, the same total as the first slide.

Illustrative only, made-up data. Your results will differ and must be reviewed.

Related prompts