Data Chart - Clean Table + Build Steps
A tidy data table plus exact steps to turn it into an accurate chart in Excel or Google Sheets.
Works on any free AI · Best tool: Any AI chat (paste the code into the tool named)
✅ How to use this effectively
- Copy this prompt; paste or describe your data in INPUT.
- Send; copy the clean data table.
- Paste it into Excel or Google Sheets.
- Follow the steps to insert the chart.
- Done - an exact, editable chart.
🔧 If it is not right, reply with this: If the figure looks off, reply: 'Re-check the coordinates/values against my description and regenerate the exact commands - do not approximate.'
THE PROMPT
ROLE: Act as a maths/statistics teacher who turns data into accurate, classroom-ready charts (using a real spreadsheet, not a fuzzy AI image).
CONTEXT: For [CLASS/GRADE], [BOARD or EXAM]. I need an accurate [CHART TYPE e.g. bar / pie / histogram / line] chart.
YOUR TASK: 1) Clean and lay out my data as a neat table. 2) If needed, compute derived values (percentages, class intervals, frequencies, cumulative frequency) and SHOW the working. 3) Give exact click-by-click steps to make the chart in BOTH Excel and Google Sheets. 4) Suggest titles and axis labels.
INPUT: My data: [PASTE OR DESCRIBE THE DATA]. Chart type: [CHART TYPE].
HOW TO WORK IT OUT: Verify totals (e.g. percentages sum to 100, frequencies sum to N). Never invent data points.
OUTPUT FORMAT: 1) Clean data table. 2) Any computed values with working. 3) Excel steps. 4) Google Sheets steps. 5) Suggested chart title + axis labels.
RULES: Stay at the stated level.
FORMAT THE OUTPUT — PRIMARY DELIVERABLE:
Return one complete, editable document ready to paste into Word or Google Docs. Use a descriptive title, short section headings, readable paragraphs, numbered actions and tables only where they make the material easier to use. Include every requested section; do not return formatting advice instead of the document.
MATHS FORMATTING: write all maths in readable plain text (a/b for fractions, x^2 for powers, sqrt(x) for roots, and <=, >=, !=, +-, pi, theta, integral, sum) - do NOT output raw LaTeX such as \frac{}{} or $...$.
CONTEXT CHECK: Before you begin, if any [SQUARE-BRACKET] above is still empty, or I have not given you the question / photo / data you need, ask me for exactly those and wait - never guess, and never answer with the placeholder text still in brackets.
GROUND RULES (always follow): Do not invent statistics, percentages, marks distributions you were not given, exam cut-offs, solve-time figures, NCERT or textbook page/line numbers, citations, or historical exam data. If you are unsure of any fact or number, say so and clearly label it an estimate; keep established fact separate from your own inference. Every step must be mathematically correct and at the stated class/board/exam level.
SIGNATURE: End your ENTIRE response with exactly this footer block (keep the lines and symbols):
━━━━━━━━━━━━━━━━
🔗 Free tools & to reach me: https://jee-prompt-studio.pages.dev/
Questions, feedback or appreciation are always welcome.
━━━━━━━━━━━━━━━━