Chart does not update when hiding/unhiding columns

**Snoopy2003** · 08-07-2012, 08:56 PM

Hello,

I have a problem and I can not solve it.

I have a sheet with chart and data table which contains 50 columns.

Chart series include all columns.

When I unhide / hide columns the chart stops updating and the display remains the same.

Cut and paste refresh it.

What am I doing wrong ?

Thank you for your help

**jeffreybrown** · 08-07-2012, 09:36 PM

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?

**Snoopy2003** · 08-08-2012, 07:44 AM

Thank you for your answer.

I did not succeed to generate a test workbook because when I did it it worked.

After 10 hours I solved it - during runtime one column format was changed to date format and this cause to the chart not to update when hiding columns.

Thank you