Home

Updating a pie chart using pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-750946%22%20slang%3D%22en-US%22%3EUpdating%20a%20pie%20chart%20using%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750946%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20been%20tasked%20with%20updating%20an%20existing%20pivot%20table%20monthly%2C%20and%20once%20the%20pivot%20table%20is%20updated%2C%20the%20corresponding%20pie%20chart%20should%20update%20as%20well.%20The%20problem%20I%20keep%20running%20into%20is%20the%20pie%20chart%20won't%20update%20with%20the%20correct%20date.%20It%20keeps%20pulling%20information%20from%20January%2C%20when%20it%20needs%20to%20reflect%20information%20for%20the%20year%20to%20date.%20I've%20tried%20changing%20the%20data%20source%2C%20but%20it%20doesn't%20change%20anything.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-750946%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-751144%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20pie%20chart%20using%20pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-751144%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F374999%22%20target%3D%22_blank%22%3E%40smargiotta225%3C%2FA%3E%26nbsp%3BCheck%20the%20data%20source%20for%20the%20chart.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWith%20charts%2C%20the%20devil%20is%20in%20the%20detail.%20Can%20you%20upload%20a%20small%20sample%20file%20(not%20your%20whole%20project)%20that%20illustrates%20the%20problem%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
smargiotta225
Occasional Visitor

I have been tasked with updating an existing pivot table monthly, and once the pivot table is updated, the corresponding pie chart should update as well. The problem I keep running into is the pie chart won't update with the correct date. It keeps pulling information from January, when it needs to reflect information for the year to date. I've tried changing the data source, but it doesn't change anything. 

 

 

 

 

1 Reply

@smargiotta225 Check the data source for the chart. 

 

With charts, the devil is in the detail. Can you upload a small sample file (not your whole project) that illustrates the problem?

 

 

Related Conversations