sponsored ads

change the legend icons in excel 2010

sponsored ads

My class want me to help him to change the legend icons in excel 2010. but I don't know it either.How can I answer it ? Asked Aug, 02 2011
add commentflag 

sponsored ads

answer this question

1 answers

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. Answered Aug, 02 2011
add comment|flag 
vote up 1 vote down

 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

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 Dec, 11 2010
vote up 0 vote down

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

Vista Ultimate Icons 1.2

Last Updated: Jan 1, 2010
License: Freeware
Filesize: 3.58MB

Continue to downloadPower by Afreecodec.com