Hello all,

I have created a dynamic chart to track stock levels for the previous 7 days, everything works great until the sheet is saved, closed and opened again - then it doesn't work! After spending hours trying to locate the issue, I noticed the series value names had changed, instead of starting with "=Sheet1!" they had changed to "=[0]!" . Once the value was changed back to "=Sheet1!" the chart works once again....

Best regards

Excel novice