Dynamic chart stops working after its saved and re-opened
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
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi,
If you are using Excel 2007, do you have at least Service Pack 2 installed? There were numerous charting bugs in the original release. Also, if you are using named ranges, don't start the name with "Chart".
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks