That happens with a chart when you specify a series of criteria that return nothing. In my case, it happens with wireless devices and error codes. I might be displaying one wireless device with Error Code A and then select another wireless device that doesn't have any records for Error Code A.
Check to see if the combination you specified actually has an intersection set (it has at least one record to display) and if it doesn't then do some sort of error handling.
Excel gets kind of funky when you ask it to do something with nothing. This happens with pivot table filters. If you try to set a filter to a value that doesn't exist, it will ask if you want to change the current value to the non-existent value.
Bookmarks