sponsored ads

how to change the text in the legend of microsoft excel 2010?

sponsored ads

Topic:  Office Microsoft Office Excel   Product:    Related Artilces:  sketchup text legend   microsoft excel uppercase legend   legend symbols bigger excel 2010
Insistshary

who knows how to change the text in the legend of microsoft excel 2010? i have no idea about this, plz give me guides, thank you.

Asked Aug, 16 2010
add comment•flag 

sponsored ads

answer this question

1 answers

Damien5

On the worksheet

   1. Click the cell that contains the data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.) name you want to change.
   2. Type the new name, and then press ENTER.

On the chart

   1. Click the chart, and then click Source Data on the Chart menu.
   2. On the Series tab, click the data series name you want to change.
   3. In the Name box, specify the worksheet cell you want to use as the legend (legend: A box that identifies the patterns or colors that are assigned to the data series or categories in a chart.) text or data series name.

You can also type the name you want to use. If you type a name in the Name box, the legend text or data series name is no longer linked to a worksheet cell.

 

MORE   office.microsoft.com/en-us/excel-help/modify-chart-legend-entries-HP010007434.aspx

 

 

Answered Aug, 16 2010
add comment|flag 
vote up 1 vote down
check

Vpatel

1. Highlight a chart by clicking on it to modify its legend .
2. Select "Source Data" from the menu .
3. Click on the tab labeled "Series".
4. Highlight the "Data series name" .
5. Place the cursor in the text box titled "Name".
6. Press the "Finish" button . Answered Apr, 15 2011
vote up 1 vote down

Damien1

 On the worksheet


   1. Click the cell that contains the data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.) name you want to change.
   2. Type the new name, and then press ENTER.

On the chart

   1. Click the chart, and then click Source Data on the Chart menu.
   2. On the Series tab, click the data series name you want to change.
   3. In the Name box, specify the worksheet cell you want to use as the legend (legend: A box that identifies the patterns or colors that are assigned to the data series or categories in a chart.) text or data series name.

You can also type the name you want to use. If you type a name in the Name box, the legend text or data series name is no longer linked to a worksheet cell.

 

MORE   office.microsoft.com/en-us/excel-help/modify-chart-legend-entries-HP010007434.aspx

Answered Oct, 30 2010
vote up 0 vote down

Search for Related Topics

comparitive boxplot microsoft excel 2010   0x8007232b microsoft excel 2010   filehippo microsoft excel 2010   microsoft excel 2010 parabola trendline   microsoft excel 2010   microsoft excel 2010 shortcutkey   microsoft excel 2010 sparklines trendlines   hippofile microsoft excel 2010   + microsoft excel 2010 foxpro autofit   iteration microsoft excel 2010   microsoft excel 2010 aerobars   microsoft excel 2010 erro

Related Unresolved Questions

more»
Your Answer

community wiki:

The Verified Code is to stop spamming. It will be hidden once your reputation reached 100.
or
 Create one

Options

sponsored ads

Download related software from AFC

Microsoft Excel Viewer 2003 1.0

Last Updated: Sep 10, 2008
License: Freeware
Filesize: 9.93MB

Continue to downloadPower by Afreecodec.com