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
Highlighted

@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
Counting Days
Tim Hunter in SQL Server on
2 Replies
my chart can not smooth the points
inadotb in Excel on
2 Replies
PWA fullscreen like IE11 kiosk mode
rogihee in Discussions on
5 Replies