+ Reply to Thread
Results 1 to 2 of 2

Change legend so that it doesn't show colors

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    Change legend so that it doesn't show colors

    Hello. The legend in my chart shows the colors of the columns. How can I make it so that it doesn't show any color in the legend box (just the series titles).

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

    Re: Change legend so that it doesn't show colors

    The legend entry reflects the formatting of the chart series.
    You could use extra series and format those whilst deleting the actual entries
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Add personal legend to chart (mixture of textboxes of different colors)
    By DrWhussi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2013, 03:30 PM
  2. Legend to follow scatter plot colors
    By skorpan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2011, 10:09 AM
  3. Replies: 2
    Last Post: 08-10-2010, 10:14 AM
  4. Colors doesn't change anymore after screen flicker fix
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-17-2009, 08:08 PM
  5. scatter plot colors/legend
    By liquidspaces in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-25-2008, 08:10 PM

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