I have data, a pivot table, and associated pivot chart sheet originally created in 2007 saved in a xlsm file. Error and empty values in the pivot table are set to show as "#N/A" so don't plot in the chart. There's also some code which makes various table field selections and creates hard-coded...