Saving Chart Names in Excel 2007

[Brett Erlandson]

I saved an XLS file as an XLSX file without performing a conversion. After
making changes to the workbook, the chart names will not save, they just
revery back to the default "Chart1", "Chart2", etc. names.

I followed these steps to change the names to no avail:
When you create charts, Microsoft Office Excel assigns a default name to
each chart by using the following naming convention: Chart1, Chart2, and so
on. However, you can change the name of each chart to make it more meaningful
to you.

Click the chart that you want to rename.
This displays the Chart Tools, adding the Design, Layout, and Format tabs.

On the Layout tab, in the Properties group, click the Chart Name text box.
Tip You may have to click the Properties icon in the Properties group to
expand the group.

Type a new name.
Press ENTER.

Any idea on how to save the names properly?

Thanks,
Brett

 

[Shane Devenshire]

Hi,

It works for me. What name are you giving the charts?

I did the following
1. Selected the chart
2. Choose Design, Layout, Properties group, clicked in the Chart Name box
and
3. Typed TestChart and pressed Enter (which doesn't seem to be necessary.)

I see the name in the Chart Name box and in the Name Box when the chart is
selected. To see it in the Name Box I need to change the selection or it
will not refresh the display.

I don not find any place on the Format tab where this is displayed?

If this is helpful, please click the Yes button

Cheers,
Shane Devenshire