LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Change Names of Legend

Taylor suggests editing the series formula, which is my favorite approach.
When you select the series, the formula appears in the formula bar. You can
select one of the arguments in the formula, or in your case, locate the
insertion point between the opening parenthesis and the comma, then click on
the cell with the series name you want displayed in the legend.
Alternatively you could type the text surrounded by double quotes.

If you don't like to change the formula (some people don't), you can open
the source data dialog, click on the series tab, select the series, click in
the Series name entry box, and either then select a cell, or type in a
label.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Elaine" wrote in message
...
Hello,

I understand that you change the actual text that appears in the legend,
not
the font of it. I tried to follow the example given on this site and
doesn't
work.

Here is the formula for one of the markers in the Chart. The formula
refers
to 2 markers on the chart. I would like one marker in the legend to be
"plastic" and the other "hardware"

=SERIES(,Sheet1!$C$2:$C$28,Sheet1!$B$2:$B$28,1)

Thank you very much for your help. This is for a presentation due on
Monday.
--
Thank you... Elaine



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Showing Series Names in Legend Andy Charts and Charting in Excel 1 March 23rd 07 02:59 PM
How do you change legend on a chart CCP Charts and Charting in Excel 3 March 20th 07 12:20 PM
Add series names to legend after the chart has been created barry Charts and Charting in Excel 3 January 15th 07 08:48 AM
avoid duplicate names in legend Khoshravan Charts and Charting in Excel 1 July 3rd 06 06:39 AM
Hide series names for unused data from chart legend Neil Goldwasser Charts and Charting in Excel 4 February 10th 06 07:13 PM


All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"