Pivot Chart - Display data in X axis (all) items regardless of count

I have a pivot chart based on this data:
Header - Month (Column A)
Data – June
Header – State (Column B)
Data – (CA, AZ)
Header – Property Type (Column C)
Data – House, Apartment, Townhome, Commercial
Header – Projects – (Column D)
Data (just random numbers)

The data in the pivot table is shown as:
Property Type on the X axis, with the total count in the y axis (bar chart), for the month of June.
I am able to display and filter on either CA or AZ and it will show the property types for either AZ or CA and the counts which is based on how many time a property type is entered into the data.

I do not have Column D in my pivot because I only want the data to count how many Property Types, not the data for the projects.

The issue I have is I want all property types regardless if they are in CA or AZ to show in the X axis. So if I chose to display CA, and there are no Condos in CA, I still want it to show with a “0”.

Can someone help me with this?
Thanks

Hi,

Welcome to the Forum.

Can you please post a sample template of your workbook using "Go Advanced" option? You may choose to delete the confidential data in the file before upload.

Thank you Andy, Is there any way to have the data say "0" if there is no data for that x axis category?

Thanks

Thanks, all the info provided me exactly what I was looking for