Dashboard Chart "unable to display chart"
I am using the pivot table to populate a chart on a dashboard from 3 columns on a sheet. Salesperson, month, contract value. that translates to a single line per sales person that I use to populate the chart.
It is designed to maintain a running total of what work the salesperson has requested to be booked versus completed booked. The chart throws the "unable to display chart" when there is no data in the pivot table to populate the chart due to all the work being completed. I know it should be as simple as creating a dummy entry, but I am not sure how to make that happen.
There are at least 50 salespeople whose data populates the pivot table which in turn populates the chart.
Help Article Resources
Check out the Formula Handbook template!