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

VB ScriptMicrosoft ExcelSpreadsheets

Last Comment

Rob Henson

8/22/2022 - Mon

Saurabh Singh Teotia

4/17/2015

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

4/17/2015

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

AckeemK

4/17/2015

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.

Your help has saved me hundreds of hours of internet surfing.

fblack61

AckeemK

4/17/2015

ASKER

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

Saurabh Singh Teotia

4/17/2015

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

4/17/2015

ASKER

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

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

Saurabh Singh Teotia

4/17/2015

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...