stop future dates from displaying on a pivot chart

chector

New Member
Joined
Jan 5, 2012
Messages
9
I have a pivot chart which tracks a count per quarter over a bunch of years. Some of the quarterly values are zero so i edited the field settings so that zeroes are displayed.. The problem this brings about is that it sets future counts to 0 also. i.e the pivot chart shows data for q3 and q4 2020 even though my dataset doesnt have q3 2020 data and q4 2020 data. I only have data up to Q2 2020 but now Q3 and Q4 contain 0 values.



How can I remove these last two data points (Q3 and Q4 2020) from my table/chart while retaining the other zero values that are legitimate?
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Watch MrExcel Video

Forum statistics

Threads
1,123,336
Messages
5,601,023
Members
414,421
Latest member
tonybear1994

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
Top