Excel chart not updating

Question

A colleague and I have a problem updating diagrams in excel.

The problem is that the chart does not update when the source data changes. This is the first time this happens to me, and I checked everywhere on the Internet, and I don't see any messages about what it looks like I have or what provides a more satisfactory solution than the vba code.

This is a simple graph. It is correctly associated with the source (no values ​​are hard-coded). Calculations are set automatically for the workbook. I really don't know where this might come from.

I tried to set up another graph on the same sheet, associated with only one simple line, and this new diagram has the same update problem as I suspect that it is related to settings or something similar, but for the life of me. cannot find which settings can do this.

Every time I want to see the updated version, I must either delete the series, or add it again, or reopen the file.

Another colleague came up with the same problem on a completely different computer / file / data / diagram.

Edit: I just created another diagram in the same sheet: 1, 2 and 01/02, 01/03

So, 1 and 2 are the source data, and the dates are the x axis.

If I change 2 to 3, the chart will continue to display 2. Even after recounting from excel. This seems to affect my whole book.

The fastest way, apparently, to get an updated chart is to cut and paste the chart back.

Answer 1

Apparently, this can happen if there is a tab in the name . . Excel doesn't seem to be like . in the tab names, and I got this error when I tried to add a new chart:

Some chart types cannot be combined with other chart types.

When I looked for the error, I got this page , which helped me understand the root cause. Then I renamed the tab to delete . , and the charts will still not be updated. Ultimately, I had to click on each series and reselect the source to update them.

When I renamed the tab, there was no error, but some internal error was supposed to cause the graphics to freeze and disconnect from cell references.

Answer 2

• Make sure you do not have a fixed limit on the axis.
• Right click on the axis, then format the axis and make sure there is no fixed maximum limit on your axis.

Answer 3

Hi, I had the same problem. Functionality is slightly different from windows, which are a little annoying!

What you need to do:

• Right click on the chart you want to update.

• In Range Information, you need to update the data range :. This will allow you to add more data than what was in the previous selection.

• Now just update the x and y values, including the horizontal axis.

If you use date on your horizontal axis, you may need to reformat it.

Good luck Dan

Answer 4

Your chart is updating, but there are no data labels. Double-click the data labels, go to the Label Settings tab and click the Reset Label Text button.

Answer 5

This is how I fixed this problem for my charts without updating the code. My problem was that the y-axis categories did not display labels when I updated them every month with new data. I tried EVERYTHING until this worked.

1) select the "select data" option on the graphs 2) highlight the first line on the right, then click the "Category" button and edit / reinstall the categories. 3) Then highlight the second series on the right, and then refresh the categories again. 4) do the same by highlighting each series and updating the categories.

In the end, all the shortcuts appeared.

Hope this helps some of you.

Answer 6

One of the answers above to select a shortcut and click the reset text message button in the label options for the chart you are working with.

I had the same problem, thanks to this information I was able to fix it.

In my case, I had a chart with hundreds of inscriptions on it. I added the following to the macro that I used to update the shortcuts, and all updates are correct again. (I'm not a chart guru, so that was a big help) I included the command I used below:

 Selection.AutoText = True 

Add the instruction to a macro that takes steps and formats text or fonts, etc. in your chart labels, and the chart should be updated again when your data changes.

I think that in my case, somehow this option was disabled. When I wrote a macro to reset the shortcut text as above so that I can see which command was posted using VBA, this is what I found. My chart now updates all shortcuts dynamically when they change in the data sheet. My chart is on page 2, and all the data shown is on page 1. I also use Excel 2013.

Thanks to the person who indicated the reset label command!

Answer 7

How are the data updated for each series? I make charts all the time at work, but usually I have a source data table on one sheet, a calculation sheet and what I want the chart to read on another sheet, and then my chart on another sheet.

Each time I update the source data table, I use a copy and paste it into the data table.

When you update your data, is the data line on the row line “#REF” or does it still say that it reads the same range and does not display anything? Sometimes my charts do not display data because the Axis range is far from my data range. Any chance of formatting the data is different than leading the chart to not recognize it? As if a number could be copied and pasted into a cell, and counted as text, not a number.