Not really sure what you are doing wrong. On a quick test I hide/unhide columns and the chart updated fine.

Do you have a sanitized workbook sample you can post?