Hi,

While viewing your window chart, go to formula area,
type =
go to your worksheet
select your cell
type enter
back to your chart, position the Text Box where you want it to appear

Each time your cell changes in your spreadsheet, the update is now
automatic in your chart ...

HTH
Cheers
Carim