Results 1 to 5 of 5

Thread: Legend help

  1. #1

    Legend help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi. I have another extremely basic question. I am trying to create a pie chart in Excel 2011 (Mac) and I can't figure out how to add the labels to the legend. "HELP" has no information on this - ridiculous. Any real help is greatly appreciated. Thanks.

  2. #2
    In form "Select Data Source" press button "Edit" which is in the right section named "Horizontal (Category) Axis Label". Then select your labels range.



    Hope that is what you were asking?

  3. #3
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,195
    Articles
    57
    Blog Entries
    14
    Jonix, welcome to the forum, and thanks for posting a solution!

    Texaslonghorn, I don't have a Mac, so just in case it is any different on that platform I asked a colleague to drop in and look as well.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  4. #4
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,195
    Articles
    57
    Blog Entries
    14
    Looks like the interface is very similar in Excel 2011 for the Mac. According to @bella_b: "the posted answer is correct. under "select data" it pulls legend labels from what's in "category (x) axis labels"."
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  5. #5
    Hello,

    In the Excel 2011 for Mac, you select the chart, right click, Select Data, and it appears like the picture, in "Category (X) axis labels" you select the cells of the labels you want.

    Click image for larger version. 

Name:	Screen Shot 2013-10-12 at 11.27.08 AM.jpg 
Views:	76 
Size:	97.1 KB 
ID:	1751
    Microsoft Excel Massive Open Online Course.
    Learn all about Microsoft excel in this Online course, with video tutorials, examples of applications and a complete functions and buttons explanation.
    Be part of our community and enjoy learning Excel.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •