Sometimes my charts dont display the data because the Axis range is way off from the range of my data.Any chance the formatting of the data is different which would cause the chart to not recognize it?Here is the way I fixed this issue for my graphs without updating code.My problem was that the y-axis categories weren't displaying the labels when I updated it each month with new data. 1) choose the "select data" option on the graphs 2) highlight the first series on the right, then click on the Category option and edit/reselect the categories.A colleague and I have an issue with the refreshing of charts in excel.The issue is the chart doesn't update when the source data is changed.Follow these steps to learn more: These “pushpin” graphics are already placed in Power Point slides.Just copy them and paste within your slides to create a look that makes a picture, shape, or anything else appear as if it has been pushed onto a surface, board, or wall with a pin!
Simple, you just summon the instance of the Excel sheet containing the chart data again and make the required changes.
Every time I want to see an updated version of it I have to either delete the serie and add it again or re-open the file.
Another colleague came up with the same issue on a completely different computer/file/data/chart.
I think in my case somehow this option was turned off.
When I recorded a macro to reset the label text as stated above so I could see what command was being placed using VBA, this is what I found.