cwwestland
New Member
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
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