+ Reply to Thread
Results 1 to 2 of 2

Remove border from legend entry without removing border from pie chart

  1. #1
    Registered User
    Join Date
    02-03-2013
    Location
    San Francisco
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    8

    Remove border from legend entry without removing border from pie chart

    Hi all,

    I can't for the life of me figure out how to remove the white borders from the individual legend entries without also removing them from the pie chart.

    Capture.PNG

    Hoping you can help!

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

    Re: Remove border from legend entry without removing border from pie chart

    You can't. The formatting of the slice is repeated in the legend entry. Without that consistency the legend could become useless.

    You can however manipulate the chart such that the legend appears how you want.
    You need to duplicate the current data set so the names are repeated. Then select each of the duplicate data points in turn and remove border formatting.
    Finally delete each of the original legend entries that are border.
    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. [SOLVED] Removing Gridlines, Axis, Chart Area Border lines etc with VBA
    By dinesh_ltjd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2014, 06:21 AM
  2. Removing Gridlines, Axis, Chart Area Border lines etc CHarts with VBA
    By dinesh_ltjd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2014, 05:32 AM
  3. Remove extra border and put all border in last row of generated output
    By cruise.alter in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-05-2012, 01:21 AM
  4. Remove Chart Area Border - Where in Code is it Added?
    By Janc in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-13-2011, 06:40 AM
  5. Replies: 1
    Last Post: 03-29-2011, 08:22 AM
  6. Removing a legend entry on a chart
    By q felt in forum Excel General
    Replies: 9
    Last Post: 05-31-2010, 07:08 PM
  7. Replies: 0
    Last Post: 01-12-2005, 10:50 AM

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