+ Reply to Thread
Results 1 to 2 of 2

Different category labels for pie chart and legend

Hybrid View

  1. 09-21-2015, 09:15 PM #1
    dongledongle
    dongledongle is offline
    Registered User
    Join Date
    09-21-2015
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    1

    Different category labels for pie chart and legend

    Hi all,

    Long time lurker, first time poster. Having a rough time trying to figure out how to get a pie graph and a legend to display different but corresponding category names. In the image below you'll see the graph and the data series (hopefully attaches correctly). Everything is fine up until the point I want C2:C14 displayed in the legend but keep the $ figures out of the chart. i.e. chart labels remain name and percentage, legend labels are name + $ amount. Any help or suggestions greatly appreciated

    EXCEL HELP.png
    Reply With QuoteRegister To Reply
  2. 09-22-2015, 02:59 AM #2
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: Different category labels for pie chart and legend

    Try XY Chart Labeler free add-in from: http://www.appspro.com/Utilities/ChartLabeler.htm
    use your column C as X axis for chart, but do not add data labels to slices standard way. in D2 write formula:
    Formula: copy to clipboard 
    =a2 & " " &TEXT(b2/b$15,"0%")

    or perhaps
    Formula: copy to clipboard 
    =a2 & char(10) & TEXT(b2/b$15,"0%")

    and copy down
    Then use column D as labels for the slices.
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Rotate x category labels in a pivot chart.
    By guntherda in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-01-2013, 06:33 AM
  2. Pie Chart - Remove Legend labels that have no value
    By Lizzie123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2013, 05:21 AM
  3. Format individual axis category labels on chart
    By emm8080 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 06-26-2012, 12:20 PM
  4. [SOLVED] Wrap category names (Y axis labels) of a scatter chart?
    By JayUSA in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-17-2012, 06:39 AM
  5. Excel 2007 : Display legend entries in chart bars (similar to data labels)
    By rasmerla in forum Excel General
    Replies: 2
    Last Post: 10-17-2011, 04:45 AM
  6. [SOLVED] Category Labels(X) axis on a chart:
    By Ali in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-19-2006, 07:55 AM
  7. Align Clustered Column Chart Category Axis Labels
    By Stephanie in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-07-2005, 11:06 AM
  8. Bar chart & Category (x) axis labels
    By Airi A. in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-15-2005, 12:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1