chart totally blank when pivot results are null

I have a pivot table that at times will have no values in it if there aren't any issues of a specific type. When I look at the chart associated with it at a time that there are values, the bar chart displays fine. On a week when we don't have any issues, the pivot table doesn't have any values and as a consequence, the chart displays as an empty box. Not a graph with no values, it's simply a white box, no titles, legend, nothing.

I've tried setting zero values to something in pivot table options and in the file/options/advanced section, but I don't think zeros or blanks are the issue. It seems to me that it's a question of a null result set. It's data we pull from our OLAP cubes, but I'm wondering if there's a way to either show an empty graph, or a message like there is in SSRS - "There's no results" kind of thing.

I am also trying to hit the "show items with no data" in the field settings, but it's disabled for some reason. I'm thinking it's prolly because it's an OLAP cube?

There are charts and there are pivot table charts The two act differently.

While pivot table charts are very agile (they adapt to changing data automatically), they are also non-adaptable. You can't "get under the hood" and tinker with them as you can with "regular" charts.

You may be able to get around this difficulty by overlaying the pivot table results with named dynamic ranges and use them as sources for the chart data. It all depends on how the pivot results look and what you want your chart to display.

I suggest that you attach a sample workbook so we can make a better determination.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

If the axis data should be static, perhaps you can use the various CUBE formulas as the source for the chart rather than the pivot table?

Overlaid named ranges deal with the data after it gets on the spreadsheet.