asked on

Pivot Tables to capture blanks but not display them

I am looking to edit my pivot tables in the 'Open SR Pivots' tab and 'Closed SR Pivots' tab to capture the blanks but not display them in the charts in the 'Charts of SRs' tab. Essentially for each of the pivots, I want to capture about 10 blank fields down in case more information is added to the data source so it is captured when the data is refreshed on the charts. However, every time I try to do so, it displays the blanks on the charts.
DSE-Carelog-Report.xlsm

Saurabh Singh Teotia

Any particular reason you using normal charts in this case..As you can use pivot charts which will auto adjust itself when the pivot table increases..Enclosed is the same for your reference of what i made a pivot chart which looks same as yours...

You can replace all your charts with pivots charts which will essentially do what you are looking for..

Saurabh...
DSE-Carelog-Report.xlsm

Flora Edwards

check it is fixed now.
DSE-Carelog-Report.xlsm

AckeemK

ASKER

Hi Saurabh,

I showed an example of adding in more values and the pivot not capturing it. Anyway to fix this? I want to add in those blank cells underneath to auto adjust as you mention but currently it is not doing so.

AckeemK

ASKER

I have attached your file back here.
DSE-Carelog-Report--6-.xlsm

Saurabh Singh Teotia

AckeemK,

I don't exactly follow what's your problem..?? If you add the new data and refresh the pivot table it will show additional data automatically but you need to do refresh manually...

Saurabh...

AckeemK

ASKER

If you notice, the Data Computing Appliance V1 and V2 even after refreshing is not in the chart.

Saurabh Singh Teotia

Yeah because you have unchecked them in the pivot table..Enclosed is the snapshot of the same for your reference..Once you check them it will automatically show...