excel Naming objects

In addition to providing names for cells and ranges, you can give more meaningful names to
objects such as pivot tables and shapes. Using meaningful names can make referring to such
objects easier, especially when you refer to them in your VBA code.
To change the name of a nonrange object, use the Name box, which is located to the left of the
formula bar. Just select the object, type the new name in the Name box, and then press Enter.
If you simply click elsewhere in your workbook after typing the name in the Name box,
the name won’t stick. You must press Enter.
For some reason, Excel doesn’t allow you to use the Name box to rename a chart. You must use
Chart Tools➜Layout➜Properties➜Chart Name.