Place a cell value on Charts
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.
.
|