0
You do not do so directly, since it is part of the chart. You can move it to various locations within the chart box. If you want to display a legend outside the chart box, you can delete the legend from the chart box and type in anything you want into cells near where you position the chart. Be aware that if you delete the legend from the chart box, you no longer will be able to update the legend when the chart changes, unless you draw the contents of the cells holding the legend data from the same location as you get the data for the chart graphic.
Wiki User
∙ 14y ago
Wiki User
∙ 12y agoYou cannot write directly in the legend. It takes its text from headings for the values on the sheet. If you have not selected them on the sheet it will just put in "Series1", "Series2" and so on. You can change series names on the sheet by adding headings or through chart settings, to change the text in the legend that identifies the option. If you want some other text, you could add a text box to the chart and put it near the legend, or even just use the chart heading.
Wiki User
∙ 9y agoWhen you initially create a chart, the legend will automatically be there. If the chart options settings, there is a section for Legend and it enables you to hide it or show it and also set its position.
When you initially create a chart, the legend will automatically be there. If the chart options settings, there is a section for Legend and it enables you to hide it or show it and also set its position.
When you initially create a chart, the legend will automatically be there. If the chart options settings, there is a section for Legend and it enables you to hide it or show it and also set its position.
When you initially create a chart, the legend will automatically be there. If the chart options settings, there is a section for Legend and it enables you to hide it or show it and also set its position.
When you initially create a chart, the legend will automatically be there. If the chart options settings, there is a section for Legend and it enables you to hide it or show it and also set its position.
When you initially create a chart, the legend will automatically be there. If the chart options settings, there is a section for Legend and it enables you to hide it or show it and also set its position.
When you initially create a chart, the legend will automatically be there. If the chart options settings, there is a section for Legend and it enables you to hide it or show it and also set its position.
When you initially create a chart, the legend will automatically be there. If the chart options settings, there is a section for Legend and it enables you to hide it or show it and also set its position.
When you initially create a chart, the legend will automatically be there. If the chart options settings, there is a section for Legend and it enables you to hide it or show it and also set its position.
When you initially create a chart, the legend will automatically be there. If the chart options settings, there is a section for Legend and it enables you to hide it or show it and also set its position.
When you initially create a chart, the legend will automatically be there. If the chart options settings, there is a section for Legend and it enables you to hide it or show it and also set its position.
Wiki User
∙ 9y agoWhen you initially create a chart, the legend will automatically be there. If the chart options settings, there is a section for Legend and it enables you to hide it or show it and also set its position.
Wiki User
∙ 10y agoA legend will be included by default. In the Chart Option dialog, there is a tab for the Legend. You can opt to show or hide the legend from here. You can format it by selecting it and right clicking on it. You can change the text used by changing the names of the series in the source data options.
Wiki User
∙ 8y agoClick on the legend and then press the Delete button. You can also just hide the legend in the chart settings, unclicking the Show Legend box.
Wiki User
∙ 9y agoIf you right click on it you will get the Format Legend option. Click on that and you will get various formatting options to choose from.
Wiki User
∙ 12y agoClick on the legend to select it. Then press the Delete key.
Add your answer:
Earn +20 pts
What identifies each bar in a chart in Excel?
The legend identifies the colors that represent the bars.
Does installing Excel 2013 remove Excel 2010?
Not necessarily. You can have two versions of Excel on one computer.
What is the box or list next to excel chart that identifies patterns or symbols?
legend
Where is the legend located on excel bar graph?
At the bottom left hand corner.....
Is the key on a graph called a legend?
In some cases it is, e.g. Microsoft Excel graphs.
Does excel have shading for legends?
If you change the colours for the items on the chart that the legend is showing to have shading, then you the legend will change too. You can also change the background of the legend itself, by right clicking on it and select the Format Legend option and then the Fill option.
How do you remove Door Speakers in Hyundai Excel 1999 Model?
How do you remove front door Panel on Hyundai Excel 1999 to Rplace front door SPEAKER'S
How do you remove the glove-box 1998 Hyundai Excel?
I have come to the conclusion myself that the only way to remove the glovebox in a Hyundai Excel is .................................................................................................................get a hammer and smash it to bits
What is a chart area in Excel?
Excel does not have a specific chart area. You might be referring to the area within a chart where you can change the legend and other information. You will find chart tools on the Insert tab of the Excel 2007 ribbon.
How do you remove the radio on a 1994 Hyundai Excel?
You don't
How do you remove water pump on a 1995 Hyundai Excel?
Dynamite
Why merge Excel sheets into notepad?
You can not merge excel documents into notepad, but you can copy data from Excel and paste it into notepad if you want to remove all of the formatting and have only plain text.
