I am trying to automate the graphs that I have in different tabs by wiriting
the date as a text box that would have the date linked to a cell in another
tab, for example the date would be on cell N1 of tab SQ_KJ, and the tex boxes
on graphs placed on other tabs (OPTG, TBG, etc)

Many thanks.
--
Moises

hi, Moises !

I am trying to automate the graphs that I have in different tabs by wiriting the date as a text box
that would have the date linked to a cell in another tab
for example the date would be on cell N1 of tab SQ_KJ
and the tex boxes on graphs placed on other tabs (OPTG, TBG, etc)

for an embedded textbox in a chart object...
- select the frame of the textbox
- begin the link with an equal-sign ( = ) IN THE FORMULA BAR
- point/select "the cell" containing "the date" (activating "the sheet") and press {enter}

you might need to use =text(<cell,"date format") in "the cell" linked to the textbox (?)

hth,
hector.

Miguel,

Thanks, it works fine.

--
Moises


"Héctor Miguel" wrote:

hi, Moises !

I am trying to automate the graphs that I have in different tabs by wiriting the date as a text box
that would have the date linked to a cell in another tab
for example the date would be on cell N1 of tab SQ_KJ
and the tex boxes on graphs placed on other tabs (OPTG, TBG, etc)

for an embedded textbox in a chart object...
- select the frame of the textbox
- begin the link with an equal-sign ( = ) IN THE FORMULA BAR
- point/select "the cell" containing "the date" (activating "the sheet") and press {enter}

you might need to use =text(<cell,"date format") in "the cell" linked to the textbox (?)

hth,
hector.


.