I'm not sure if what I am trying to do is possible. I have a chart set up as
a series for 2005 and 2006. The legend shows 2005 & 2006. I would like to
incorporate a cell reference in the legend field, but have been unsuccessful.

For the first series it shows "2005" in the name box. I would like it to
include the text "2005" but also add a cell reference, i.e. "2005 - " &
mysheet!G4. My hope is that the legend would then display, 2005 - 12,345.

Can this be done? If yes, how? I have tried various formula combinations
to do it, but no luck.

TIA
Jan

Put the formula in the cell that the series uses for its legend.

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


"Jan" wrote in message
...
I'm not sure if what I am trying to do is possible. I have a chart set up
as
a series for 2005 and 2006. The legend shows 2005 & 2006. I would like
to
incorporate a cell reference in the legend field, but have been
unsuccessful.

For the first series it shows "2005" in the name box. I would like it to
include the text "2005" but also add a cell reference, i.e. "2005 - " &
mysheet!G4. My hope is that the legend would then display, 2005 - 12,345.

Can this be done? If yes, how? I have tried various formula combinations
to do it, but no luck.

TIA
Jan

Acutally, the legend name was typed in the name box; it was not reference to
a cell.

"Jon Peltier" wrote:

Put the formula in the cell that the series uses for its legend.

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


"Jan" wrote in message
...
I'm not sure if what I am trying to do is possible. I have a chart set up
as
a series for 2005 and 2006. The legend shows 2005 & 2006. I would like
to
incorporate a cell reference in the legend field, but have been
unsuccessful.

For the first series it shows "2005" in the name box. I would like it to
include the text "2005" but also add a cell reference, i.e. "2005 - " &
mysheet!G4. My hope is that the legend would then display, 2005 - 12,345.

Can this be done? If yes, how? I have tried various formula combinations
to do it, but no luck.

TIA
Jan

The Name Box I was referring to is the box above the first column header to
the left of the formula bar, which displays the name of the selected object.
If you select a series named "2005" the Name Box will display "2005".

I think you're referring to the Name entry box in the Source Date dialog,
Series tab. You can type a name here, and the name of the series will be the
name you types. Or you can link to a cell here, and the series name will be
whatever is in that cell.

So put the formula into a cell, for example, in cell C1 enter this formula:

=-"2005 - "&mysheet!G4

Then in the Source Data dialog, Series tab, with this series selected, enter
this link formula into the Name entry box:

=mysheet!C1

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


"Jan" wrote in message
...

Acutally, the legend name was typed in the name box; it was not reference
to
a cell.

"Jon Peltier" wrote:

Put the formula in the cell that the series uses for its legend.

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


"Jan" wrote in message
...
I'm not sure if what I am trying to do is possible. I have a chart set
up
as
a series for 2005 and 2006. The legend shows 2005 & 2006. I would
like
to
incorporate a cell reference in the legend field, but have been
unsuccessful.

For the first series it shows "2005" in the name box. I would like it
to
include the text "2005" but also add a cell reference, i.e. "2005 - " &
mysheet!G4. My hope is that the legend would then display, 2005 -
12,345.

Can this be done? If yes, how? I have tried various formula
combinations
to do it, but no luck.

TIA
Jan