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
Highlighted
Deleted
Not applicable

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

@Deleted 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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies