Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Saving Chart Names in Excel 2007

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
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 857
Default Saving Chart Names in Excel 2007

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

"Brett Erlandson" wrote in
message ...
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart template not saving title formats - Excel 2007 Tammy Charts and Charting in Excel 3 October 8th 08 01:47 PM
Excel 2007 not saving user-created range names Bruce Excel Discussion (Misc queries) 0 August 27th 08 08:49 PM
Office 2007 Names - Why can't it start with Chart? Barb Reinhardt Charts and Charting in Excel 10 August 7th 08 04:44 AM
Excel 2007 - Dynamic names for chart series jcollot Charts and Charting in Excel 2 December 13th 07 08:12 PM
Saving Excel 2007 chart as web-page Eugene Komaristy Charts and Charting in Excel 0 July 5th 07 07:44 AM


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"