Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart template not saving title formats - Excel 2007 | Charts and Charting in Excel | |||
Excel 2007 not saving user-created range names | Excel Discussion (Misc queries) | |||
Office 2007 Names - Why can't it start with Chart? | Charts and Charting in Excel | |||
Excel 2007 - Dynamic names for chart series | Charts and Charting in Excel | |||
Saving Excel 2007 chart as web-page | Charts and Charting in Excel |