+ Reply to Thread
Results 1 to 4 of 4

Chart legend adds verbiage "(small team)" at end of data series name

  1. #1
    Registered User
    Join Date
    01-16-2013
    Location
    Erie
    MS-Off Ver
    Excel 2007
    Posts
    2

    Chart legend adds verbiage "(small team)" at end of data series name

    I have a chart with a legend on it. The legend displays the names of the data series in addition to the line that is representing that series. One of the series is named "Current". However, on the legend it reads "Current (small team)". When you mouse over it, it says "series 'Current' trendline...". The words "small team" aren't in the trend name anywhere.

    Is there some sort of setting or function that excel adds this?

    You can't just click in and delete the "small team" verbiage or else it delete the entire trend. The cell that it is pointing to for the series name reads "Current" not "Current (small team)" like the legend displays.

    Thank you!

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Chart legend adds verbiage "(small team)" at end of data series name

    right-click the trendline in the chart, choose 'format trendline...' and check if it was given a custom name
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    01-16-2013
    Location
    Erie
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Chart legend adds verbiage "(small team)" at end of data series name

    Quote Originally Posted by JosephP View Post
    right-click the trendline in the chart, choose 'format trendline...' and check if it was given a custom name
    So simple and I couldn't find it...Doh! Thank you!

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Chart legend adds verbiage "(small team)" at end of data series name

    you're welcome :-)

    please don't forget to mark the thread solved (click the 'thread tools' link at the top, then 'mark solved')

+ 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