BUG: informative error message with Series ValueError

Fixes issue #6532.