Pivot table issues

C

Camel123

Board Regular
Joined
Jun 5, 2018
Messages
186
Hi,

I have created a template for providing monthly reports on financial figures. I paste 1x row per project in sheet(1), then I have 7x sheets with the exact information (they are all linked). To those 7x sheets I have 7 different pivot tables.

When I update sheet(1) with new information and refresh all Pivot Tables, in the PivotChart Fields>field: Project names I need to filter all project names manually to show up in the chart. Is there a way to just click the refresh button and get an updated chart without manual adjustments in the pivotchart fields?
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sort by date Sort by votes
If I understand what you need:

Open the Pivot Table Field List and click on the filter field ....

... then Field Settings there should be a tick box at the bottom "Include new items in manual filter"
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Question Question
Retaining structure of Pivot table after refresh
Replies
1
Views
162
Alex Blakenburg
A
C
  • Solved
Automatically refresh pivot table filter to remove spaces and blanks
2
Replies
15
Views
507
Alex Blakenburg
A
SandsB
  • Question Question
Chart Type changes when updated
Replies
0
Views
42
SandsB
SandsB
D
  • Question Question
Pivot Table Refresh Issue
Replies
7
Views
783
Alex Blakenburg
A
ghull99
  • Question Question
Attempting VBA to refresh "Chart Title" based on Pivot Filters. Filter1 works in VBA, but title doesn't update based on filter2.
Replies
0
Views
49
ghull99
ghull99

Forum statistics

Threads
1,223,889
Messages
6,175,226
Members
452,620
Latest member
dsubash

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top