Charts not updating when data is updated

Unlike Cliff, I had no trouble downloading the example file. Don't worry about the settings you put onto the download file because they were correct. I even posted a screen shot from your workbook, which proves I was able to download the file.

I looked through your file and observe you carefully and thoroughly removed information that would be personal or confidential. You even went so far as to change the user to a generic: Microsoft Office User.

I don't know why Cliff thought it would be OK to change your post and remove your link. I do not think removing your link was OK.

At any rate, I looked through the charts and I don't see any that have English language headings. Can you help me find a specific chart example? Which tab and where on the sheet is the chart you showed in your screenshot?

I'm using US English as my Mac OS system default. Perhaps there's a language localization issue, but I am using version 16.61 (beta channel). Try updating to version 16.60 when it becomes available to you and see if that changes the situation.

Dear Jess,

Thanks for your updates.

It seems that you shared the file from the personal OneDrive online place which we may be unable to get it based on the limited network environment.

As the forum is public, I'd like to confirm whether the file and the file link can be shared here directly. If yes, please add your confirmation and we'll remove the link after 24 hours to protect your privacy if there is no confirmation from you.

For us to get the file, I'd like you to provide the file in the private message.

Thanks for your understanding and have a nice day!

Cliff

Hi

Are you talking about labels like this one? It won't update because it is not part of the chart. It is a text box that was added to worksheet and is independent of the data. Notice the object name in the name box when the object is selected.

Thank you for your response. Here is a link to a sample file where this is happening. It's happening repeatedly and in several versions of the same file, but not consistently. It is also happening on Excel for web.

Here is *** of what I am referring to. The dashboard was created in English and I am translating it to French. I updated the cells by copying and pasting text from a Word document. On the first tab (Toutes les réponses – Sommaire), the charts from row 113 down reference cells B6:B30 for the title of the charts. You can easily see that some charts updated to French but the title of several charts beginning at row 205 are still in English despite the cells they reference being in French. On the other tabs, this is not the case. I copied and pasted the same French text into the cells those titles are referencing and the titles all updated correctly (though I haven't changed the language in all the formulas yet so the charts have not updated completely).

I appreciate your help and hope you can help me resolve this.

Dear Jess,

Welcome to the forum here.

Generally, if you use the formula reference to update the cell, the cell should be updated.

To confirm whether the issue is related to the specific file, I'd like you to copy the part of cells and the reference cells to a newly created file and then do a test to see if it works in your environment.

Meanwhile, to confirm how you update the cell, I'd like you to upload some screenshots showing the sample data source and how you update the cell for our reference.

Note: Remove any private information before uploading the screenshots.

Moreover, if the file contains no features not supported in Excel for web, I suggest you upload the file to a online place such as OneDrive for Business or SharePoint Online and do a test in Excel for the web to see if the issue disappears in Excel for the web.

Thanks for your effort and time.

Cliff