Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CHANGING LEGEND TEXT | Charts and Charting in Excel | |||
Changing legend Text | Charts and Charting in Excel | |||
Changing only Legend Text | Charts and Charting in Excel | |||
Changing the Legend | Charts and Charting in Excel | |||
Changing the width of the legend key | Charts and Charting in Excel |