If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I can't change the label in legend
I'm trying to modify a legend in a project that was
designed by someone else. Next to each colored box, there's a label which I need to change. I've tried everything I can think of, the last of which was highlighting my pie chart and right clicking. I chose "Source Data" and clicked on "values". I thought that if I could change it in that cell it would automatically update my legend. When I highlighted the cell, it showed marching ants and would not let me do anything to it. I'm very new to this. Please tell me in as simple a way as possible! Thank you so much (in advance). |
#2
|
|||
|
|||
I can't change the label in legend
To change the labels, go back to Source Data, and make note of where in
the worksheet the legend entries come from in the Category Labels edit box. Close the dialog, and change the text in the appropriate cells. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ NGold wrote: I'm trying to modify a legend in a project that was designed by someone else. Next to each colored box, there's a label which I need to change. I've tried everything I can think of, the last of which was highlighting my pie chart and right clicking. I chose "Source Data" and clicked on "values". I thought that if I could change it in that cell it would automatically update my legend. When I highlighted the cell, it showed marching ants and would not let me do anything to it. I'm very new to this. Please tell me in as simple a way as possible! Thank you so much (in advance). |
Thread Tools | |
Display Modes | |
|
|