I have a chart where I would like one of the legend keys to read:
"Current Weight as at..."
and then whichever date I have selected from the valiation list in cell B3.
I thought, within the source data menu, I could just change the series name to something like ="Current Weight as at...