Hi xor,




In your message you wrote that you "...set up formulas so that the chart automatically...". I looked at ARM.xls and searched for formulas. Using the ASAP Utilities app I searched for formulas and the app did not find any in the ARM.xls file.


I did manage to recreate the worksheet table and chart though, by copying the table, pasting it into Notepad, copying it from Notepad and then pasting it back into where it came from in the worksheet.


I appreciate your help, and am saving ARM.xls just in case the problem returns.

They're in the Name Manager and the chart plots those names.

Hmmm... My Excel 2000 does not have a Name Manager. It does have a Name function when I pull the Insert menu down, and that function has Define, Create, Paste, Apply, and Label options. Since beginning with Excel in 2000, I have never used the Name function and I have quite a few tables that do have formulas in them. However, this particular XLS file does not contain any formulas.



@XOR
No, I have utilized the help that was given to me and I was able to fix the problem, so I don't think I need any more explanation.

Gosh.
The names and formulae are:
2023-03-27_163117.png


Highly recommended utility that was used a lot 'back in the day' before Microsoft caught up with their own:
Free Name Manager Excel add-in