Display message in chart if no data is available

[cwwestland]

Hello,


I have several pie charts in Excel 2007 that pull data from a table of errors for each of our locations in a specific function. The data will change every day and there will be days when certain locations do not have any errors. When the table is empty as it would be on a day with no errors, the chart is still there, but the "pie" is gone and just the legend remains. Is there a way to display, "NO ERRORS", or some other message when there is no data in the chart. I have not been able to find anything online for this.


Thanks,

Chris

 

[Trader273]

See if this points you in the right direction:


https://www.dropbox.com/s/8fml9ulw1dnh5ay/Show%20Pie%20when%20Data.xlsm

 

[cwwestland]

The link is blocked at work, but I will check it out when I am home, thanks!