+ Reply to Thread
Results 1 to 3 of 3

Exclude one data series from scatter chart legend (but not from the chart)

  1. #1
    Forum Contributor
    Join Date
    04-26-2009
    Location
    Austin, TX
    MS-Off Ver
    Excel 2016
    Posts
    241

    Exclude one data series from scatter chart legend (but not from the chart)

    Hi Everyone,

    is there a way to exclude one data series from a scatter chart legend, but still have the data plotted on the chart? Specifically, the other four data series would have their colored markers and names appear in the legend, but this one data series, while plotted on the scatter chart, would not be included in the legend.

    Is it possible? Is it easy?

    Cheers,

    Jay
    Last edited by JayUSA; 05-29-2012 at 05:24 PM. Reason: Solved

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Exclude one data series from scatter chart legend (but not from the chart)

    Hi Jay,

    If you go to the legend >> click once >> the entire legend is highlighted >> click again on the specific date series and only that data series is highlighted.

    Now delete on your keyboard.
    HTH
    Regards, Jeff

  3. #3
    Forum Contributor
    Join Date
    04-26-2009
    Location
    Austin, TX
    MS-Off Ver
    Excel 2016
    Posts
    241

    Re: Exclude one data series from scatter chart legend (but not from the chart)

    Great, thanks!!

+ 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