recently excel reported a repair need when I tried to open my file and at the end deleted existing charts; after this happened excel does not allow me to add charts.
The message is as follows:
"Select the cells that contain the data that you want to use to create the chart. If you've named rows and columns and want to use them as labels, add them to your selection."
Did you experience such a situation?