Audit beginner Works with: Any AI

Excel Chart Source Range and Labelling Accuracy Audit

Table output

Check that charts show the data they claim to.

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…

Audit charts. For each chart: title, type, source range, axes and scales, series names, labels, and the table or numbers it should represent: [CHART_DETAILS].

Check that ranges include all rows and no stray totals, series names are right, axis scales start where they should, labels show units, sorted order is intended, hidden rows are or are not plotted as desired [VERIFY], and colours are consistent for the same category across charts. For each chart verify: click the series to see its range [VERIFY], compare the first and last data points with the table, check whether new rows will be included (use tables or dynamic ranges), and confirm the title says what the chart shows and the period. Recompute two plotted values by hand.

Worked example: a chart range stops at row 41 while the data runs to row 44, so the last three months are missing; the fix is to extend the range or base the chart on a table. Count the charts with a problem and show the share. Return a table of fixes, a way to test on a small sample first, and a pre-send checklist for reports with charts. A chart must agree with the numbers beside it. Flag version-dependent points [VERIFY].

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.

Related prompts