Hi guys,
I have a weird issue. I have a large excel file with five countries, each having a sheet where the data is stored and a separate sheet with charts based on that data - 10 sheets in total.
Each country is set up in an identical way, data and graphs. Yesterday one of the graphs stopped showing the data, going blank except for the legend entries. I checked and the data feed in the chart options is still there and correct, and I made no changes to the data.
I then tried creating a new chart with identical data feed, and it worked, until I saved and reopened the file - then it was blank, the same as the first one.
It is weird because this is happening only to this one graph (I have 16 graphs per country), and only for one country.
I have similar issues with more of the graphs in PowerPoint, but that i a bit of a different story - some of the data does not refresh in some graphs after saving and opening again.
Any insight would be appreciated, I have no idea what else to try.
Thanks,
Jurij
I have a weird issue. I have a large excel file with five countries, each having a sheet where the data is stored and a separate sheet with charts based on that data - 10 sheets in total.
Each country is set up in an identical way, data and graphs. Yesterday one of the graphs stopped showing the data, going blank except for the legend entries. I checked and the data feed in the chart options is still there and correct, and I made no changes to the data.
I then tried creating a new chart with identical data feed, and it worked, until I saved and reopened the file - then it was blank, the same as the first one.
It is weird because this is happening only to this one graph (I have 16 graphs per country), and only for one country.
I have similar issues with more of the graphs in PowerPoint, but that i a bit of a different story - some of the data does not refresh in some graphs after saving and opening again.
Any insight would be appreciated, I have no idea what else to try.
Thanks,
Jurij