A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

changing the name in the legend



 
 
Thread Tools Display Modes
  #1  
Old March 20th, 2010, 05:14 PM posted to microsoft.public.excel.charting
Charles Eaves[_3_]
external usenet poster
 
Posts: 6
Default changing the name in the legend

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


  #2  
Old March 20th, 2010, 07:44 PM posted to microsoft.public.excel.charting
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default changing the name in the legend

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


.

  #3  
Old March 22nd, 2010, 01:05 AM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default changing the name in the legend

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:42 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.