Excel 2007 on XP.
I'm having trouble making a pivotchart display dates equidistantly and include zero values when all dates are not present in the orginal data.
See document attached. Book1.xls
I've tried:
Field Settings>Show items with no data
PivotTable Options> For empty cells show: 0
Am I missing something?
Thanks.
Bookmarks