Chart, Series - Name box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top