Legend help

texaslonghorn

New member
Joined
May 30, 2011
Messages
8
Reaction score
0
Points
0
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.
 

jonix

New member
Joined
Jun 20, 2011
Messages
3
Reaction score
0
Points
0
In form "Select Data Source" press button "Edit" which is in the right section named "Horizontal (Category) Axis Label". Then select your labels range.

labels-excel-2007.PNG


Hope that is what you were asking?
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,521
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
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

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,521
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
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"."
 

jsuarezg

New member
Joined
Sep 21, 2013
Messages
24
Reaction score
0
Points
0
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.

Screen Shot 2013-10-12 at 11.27.08 AM.jpg
 
Top