"Add a series to start visualizing your data" error and missing visuals in several sheets

Sorry for the late response, @bwentwor… I THINK Sheets is asking you if you want to link the chart to a data range in a hidden part of your spreadsheet. Do you see another dialog with an “Include data” button hovering over your spreadsheet? If not, you might try unhiding the hidden columns at right and then rehiding them.

Hope this helps.