Pivot charts don't uppdate automatically when source data changes. You either have to refresh it manually: select graphh -> Analyze -> Refresh or include some code. See here: http://www.get-digital-help.com/2011...able-in-excel/