Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Showing Series Names in Legend | Charts and Charting in Excel | |||
How do you change legend on a chart | Charts and Charting in Excel | |||
Add series names to legend after the chart has been created | Charts and Charting in Excel | |||
avoid duplicate names in legend | Charts and Charting in Excel | |||
Hide series names for unused data from chart legend | Charts and Charting in Excel |