Forum Discussion
Pivot Chart Summing Incorrect
Hi all,
I'm currently working on a report that details the total time it takes to solve an issue.
I am at the point where I have a pivot table with all the data but when I create a Pivot chart for some reason the data changes.
The issue I am having is that the data in the chart subtracts 1 day from the data shown in the pivot table.
The pivot table number format is: d "days" hh "hrs" mm "mins"
And shows for example in the sum column: 10 days 00 hrs 45 mins
However when put into a pie chart this sum changes to: 9 days 00 hrs 45 mins.
For every sum / average in the pie chart it subtracts 1 day from what is in the Pivot table.
Why is this happening?
Thanks so much.
4 Replies
SergeiBaklan , Pivot chart is considering 30 as zero.
Also, when sum is >61 , the pivot chart shows OK values.
Is this any clue?
That's attempt to correct leap year bug Excel incorrectly assumes that the year 1900 is a leap year - Office | Microsoft Docs. 30 here means 30 Dec 1899. After sum is more than 61 (total days in Jan and Feb of 1900) result shall be correct, leap year bur doesn't affect the rest.
The question is not why so, question is how to force PivotChart to show correct number of days before 61.
