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 cha...
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.
SergeiBaklan , 98x2S , how about using a workaround by introducing a calc column for charting?
(user to refer good table and good chart and ignore bad table and bad chart)
time taken_calc=IF(SUMIF([issue],[@issue],[time taken])<61,[@[time taken]]+1/COUNTIF([issue],[@issue]),[@[time taken]])
