Cleared Chart Legend - How to Get it Back?
Cleared Chart Legend - How to Get it Back?
(OP)
Once I've cleared an Excel data series chart legend entry, how do I turn it back on?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
Cleared Chart Legend - How to Get it Back?
|
RE: Cleared Chart Legend - How to Get it Back?
1) On chart page, Chart/Chart Options/Legend, check "Show Legend" and check one of the locations, (Bottom, etc.)
If you are talking about getting just the text for one entry in the legend, try this:
2) On chart page, Chart/Source Data/Series. At the bottom left will be a list of all the data series you have plotted on your chart. Select the data series which you want to name. In "Name:" at the right, you'll see what will appear in the Legend when the Legend is turned on. You can type some text in the Name: box, or you can click on the small button to the right of this Name: box (called the Collapse Dialogue button), then point to a navigate to a worksheet, and select the cell which has the text you want in the legend for this data series.
RE: Cleared Chart Legend - How to Get it Back?
Sometime in the past, someone might have clicked in the legend itself and cleared it. How would I undo that?
RE: Cleared Chart Legend - How to Get it Back?
I don't know if you do backups--sometimes it's worth it to return to the backup directory and restore what was there.
RE: Cleared Chart Legend - How to Get it Back?
RE: Cleared Chart Legend - How to Get it Back?
I don't know if this is your problem, but I've had this happen before. The Name: box points to a cell in a worksheet. I delete the row or column with that particular cell. Now the Name: box shows #REF! because I've deleted the reference. There is another instance that showed <blank> in the Name: box, but now I can't recreate that instance, so I can't tell you why <blank> showed up.
RE: Cleared Chart Legend - How to Get it Back?
To clear I select the legend, select the series name, then right click and select clear. Poof, it's gone. I just don't know how to undo it without recreating the whole series.
RE: Cleared Chart Legend - How to Get it Back?
that's me, knocking my head with a stick. So here's what I did. I selected the legend in my chart, then clicked the entire label for my Series 1. Delete button makes it go away with no apparent way to retrieve it. What if I select the ENTIRE LEGEND, then delete? Legend gone. Now I went to Chart/Chart Options/Legend, checked "Show Legend" and checked one of the locations, (Bottom, etc.). The Legend reappears with the Series 1 label and symbol that I deleted in the previous step. Does that work for you?
RE: Cleared Chart Legend - How to Get it Back?
RE: Cleared Chart Legend - How to Get it Back?
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.