I created a pivot table and a pivot chart from external data (SQL Server). For both the table and the chart I need to show zeros (0.0) for empty cells. While it was easy to do for the table (Pivot Table options -> For empty cells show -> 0.0), I can't find a corresponding option for the pivot chart data table. By default the data table shows empty cells rather than the desired values (0.0) and I can't find a way to change it.

Thank you very much in advance for any suggestions,