+ Reply to Thread
Results 1 to 5 of 5

Renaming charts in Excel 2007

  1. #1
    Forum Contributor
    Join Date
    08-22-2005
    Location
    Denmark
    MS-Off Ver
    Excel 365
    Posts
    349

    Renaming charts in Excel 2007

    In the old Excel it is possible to rename a chart by pressing SHIFT+Mouse Click and then write a new name in the upper left corner name box.

    You can apparently do the same thing in Excel 2007, but the new name doesn't stick.
    Someone has a hint?

    NSV
    Last edited by nsv; 02-17-2010 at 01:07 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Renaming charts in Excel 2007

    Try using

    Chart Tools > Layout > Properties > Name
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    08-22-2005
    Location
    Denmark
    MS-Off Ver
    Excel 365
    Posts
    349

    Re: Renaming charts in Excel 2007

    Found it at last!
    Thanks Andy

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Renaming charts in Excel 2007

    Hi,

    ...perhaps not directly related to your specific question but something about which you should be aware. If you create a chart in 2007 and rename it from the default 'Chart1' name, and then subsequently copy and paste it (if for instance you are wanting a similar chart but for some different data), then the second copy of the chart will have the same name

    Be aware of this and if you use a macro to copy and paste a chart which you've previously renamed, make sure you also change the name whilst it's still the active chart.

    This anomaly doesn't seem to occur if you just accept the system's default chart names. Copies will change to Chart2, Chart3 etc.

    Rgds
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  5. #5
    Forum Contributor
    Join Date
    08-22-2005
    Location
    Denmark
    MS-Off Ver
    Excel 365
    Posts
    349

    Re: Renaming charts in Excel 2007

    OK - thanks for the tip

    NSV

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1