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