Naming a Chart
 

Excel 2000 Power Programming with VBA states that naming
an object requires selecting the object (such as a chart),
typing the new name in the Name Box, and pressing Enter.
This does work for a shape but not a chart. When I select
a chart and attempt to enter anything in the Name Box, any
entry is not enabled and therefore nothing happens. How
can I assign a name to a chart???

Hold the Shift key (or the Ctrl key), and click on the chart to select it.
Then, type a name in the Name Box, and press the Enter key.

William Bartusek wrote:
Excel 2000 Power Programming with VBA states that naming
an object requires selecting the object (such as a chart),
typing the new name in the Name Box, and pressing Enter.
This does work for a shape but not a chart. When I select
a chart and attempt to enter anything in the Name Box, any
entry is not enabled and therefore nothing happens. How
can I assign a name to a chart???


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

try holding down the shift key and then select the chart and then goto the
name box

--
Don Guillett
SalesAid Software

"William Bartusek" wrote in message
...
Excel 2000 Power Programming with VBA states that naming
an object requires selecting the object (such as a chart),
typing the new name in the Name Box, and pressing Enter.
This does work for a shape but not a chart. When I select
a chart and attempt to enter anything in the Name Box, any
entry is not enabled and therefore nothing happens. How
can I assign a name to a chart???