In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
Choose the Right Chart for Your Message
Prompt
The single point I want the viewer to take away: {{KEY_MESSAGE}}
Data: columns, types and number of categories or time points: {{DATA_SHAPE}}
Audience and where they will see it (slide, printed report, dashboard, email): {{AUDIENCE_AND_MEDIUM}}
App: {{SPREADSHEET_APP}}
Recommend:
1. The best chart type and a reason tied to the message, plus two alternatives and when each would be better. Say which common choices to avoid for my data (for example pie charts with many slices, 3D effects, dual axes).
2. How to set it up: which fields go on which axis, sorting order, and what to do with long category names.
3. What to emphasise (one highlight colour, direct labels instead of a legend) and what to remove (gridlines, borders).
4. Axis decisions: where the baseline should start for my chart type, and why.
5. A title written as a finding, not a topic label, based on my key message only; do not insert numbers I didn't give.
6. Accessibility: colour-blind safe choices and text size.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Choose the Right Chart for Your Message” is a free prompt for ChatGPT in the Productivity category, 181 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{KEY_MESSAGE}}, {{DATA_SHAPE}}, {{AUDIENCE_AND_MEDIUM}}, {{SPREADSHEET_APP}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 7 times.
Browse all Productivity prompts, the AI prompt database or use the AI prompt finder to search every prompt.