Why does a chart total not agree with the count in my schedule?
Quick answer
Reconcile the chart and schedule by checking that they include the same records and count the same thing. Inspect the chart’s selected source range, then check for hidden rows or columns and possible duplicate records. In Excel, charts do not show worksheet data hidden in rows or columns by default, though a chart setting can show it. [S1] Write down the schedule count and chart total using the same definition before comparing them.
The question, the details, the next step.
Why does a chart total not agree with the count in my schedule? I can see the records, but the number on the chart is different.
Start by treating this as a reconciliation, not as proof that either number is wrong. Write down what each number is meant to count—for example, number of scheduled jobs versus total hours—and which records each includes. Then compare those definitions.
Check the chart’s selected source range against the schedule rows you counted. A range that omits some intended rows or includes unintended ones can make the chart summarize a different set of records. Also check whether the chart summarizes the same measure you counted in the schedule. A count of records and a sum of hours are not directly comparable just because both are displayed as totals.
Keep a note of the original figures while you investigate. That makes it easier to see which check explains the difference.
I’m using Excel. Could hidden or filtered rows explain it, even if I didn’t delete anything?
Hidden rows or columns can be relevant in Excel: charts do not display worksheet data hidden in rows or columns by default. Excel’s chart setting for hidden and empty cells includes an option to show data in hidden rows and columns. Check whether schedule rows or columns are hidden, and inspect that chart setting before deciding the chart is missing records. [S1]
For filters, note what is currently included in your schedule count and compare it with the records the chart is intended to represent. Keep the inclusion rule the same when you compare the two totals. Check the workbook’s actual ranges and settings rather than assuming a filter or chart behaves a particular way.
What should I look for if the source range and visible rows seem right?
Look for repeated records and clarify the unit being counted. A repeated ID might be an accidental duplicate, or it might represent two legitimate scheduled entries; do not delete it just to force the totals to match. Instead, mark suspected repeats for review and decide what one record means for this comparison.
Then write the measure in plain language. Are you counting every row, distinct IDs, completed items, or a numeric amount? Compare like with like. For example, if your schedule count is “rows with a job ID” but the chart summarizes “hours,” the difference may be expected. The right treatment of possible duplicates and the right measure depend on your records and the question you want the chart to answer.
Can you give me a simple reconciliation template I can use before changing the chart?
Use this copyable note, filling in the brackets before editing anything:
Schedule count: [number]
Chart total: [number]
Compared measure: [rows / distinct IDs / hours / other]
Records included in schedule count: [rule]
Chart source range: [range or description]
Hidden rows or columns checked: [yes/no; finding]
Filter or inclusion rule: [description]
Possible duplicate records reviewed: [yes/no; finding]
Difference explained by: [finding, or not yet known]
Check one item at a time and record what you find. If the difference remains, mark it unresolved rather than adjusting the chart or deleting records without knowing why. The useful outcome is a documented comparison with matching definitions, not simply two numbers that happen to agree.
A practical checklist
Write down the schedule count, chart total, and the precise measure each represents.
Compare the chart’s selected source range with the intended schedule records.
Check hidden rows or columns and, in Excel, the chart setting for showing hidden data. [S1]
Record the filter or inclusion rule and use the same rule for both totals.
Review possible duplicates without deleting records merely to make totals agree.
Document the cause, or label the difference unresolved if you cannot verify it.
A few more useful answers
Should I change the chart setting to show hidden rows?
Only if hidden rows are meant to be included in that chart. First decide which records the chart is intended to represent, then check the setting and compare against those records. [S1]
Should I remove duplicate rows when the totals differ?
Not just to make the totals match. Mark suspected repeats, determine whether they represent the same record or separate valid entries, and apply a consistent counting rule.
What if I still cannot explain the difference?
Keep the original figures and note the range, measure, inclusion rule, and hidden-row checks you made. Leave the comparison unresolved until you can verify why the numbers differ.
Sources
References used for this guide.
- [S1] Display empty cells, null values, and hidden worksheet data in an Excel chart support.microsoft.com · Checked