Changing Legend Text

[TylerJamison]

For the life of me, I cannot figure out how to change the text inside the legend to what I need it to be. I've attached the spreadsheet I'm working with. Be forewarned, this is homework, so if you could just walk me through how to do it, that's fine with me.

I need "2" in the legend to be ""Preferred Hand" and "Best of 10/11" to be "Non-Preferred Hand".

Thank you for your help!

Winter 2014 Bilateral Transfer.xlsx

[LJMetzger]

Hi Tyler,

Thank you for indicating that this is homework.

Excellent question and not trivial.

See http://stackoverflow.com/questions/1...chart-in-excel for instructions. One of the clues in that post may help you.

If you do an Internet search on 'Excel xxxx' where 'xxxx' is the problem you are having, quite often you will get a solution to your problem.

Lewis

[LJMetzger]

Deleted - previous post submitted twice accidentally.

[Andy Pope]

Your chart has 1 series, which normally would provide 1 legend entry and the text displayed would be the series name.
If you format individual data points then you will get a legend entry for each data point. Given there are only 2 showing I assume you deleted all the others from the legend.

You either need to change the text associated with each data point or more simply use 2 data series.