Prev: Pareto charts and Run Charts
Next: Can't update my chart
From: Charles Eaves on 20 Mar 2010 12:14
I am using Excel 2007 with XP Home.
I am a newbie.
I am looking at the legend on a bar chart.
Without changing my spreadsheet, how do you change the legend name say from
"BOB" to "BOBBY" on the chart without changing the spreadsheet.
Thanks


From: trip_to_tokyo on 20 Mar 2010 14:44
Delete the Legend and use a Text Box.

If my comments have helped please hit Yes.

Thanks.




"Charles Eaves" wrote:

> I am using Excel 2007 with XP Home.
> I am a newbie.
> I am looking at the legend on a bar chart.
> Without changing my spreadsheet, how do you change the legend name say from
> "BOB" to "BOBBY" on the chart without changing the spreadsheet.
> Thanks
>
>
> .
>
From: Jon Peltier on 21 Mar 2010 20:05
The legend displays the series name, which is taken from the worksheet.
The easiest way not to change the cell that is currently used for the
series name is to go to the source data dialog, and replace the cell
address for the series with the name you want, in double quotes.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 3/20/2010 12:14 PM, Charles Eaves wrote:
> I am using Excel 2007 with XP Home.
> I am a newbie.
> I am looking at the legend on a bar chart.
> Without changing my spreadsheet, how do you change the legend name say from
> "BOB" to "BOBBY" on the chart without changing the spreadsheet.
> Thanks
>
>
 | 
Pages: 1
Prev: Pareto charts and Run Charts
Next: Can't update my chart