View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Héctor Miguel Héctor Miguel is offline
external usenet poster
 
Posts: 434
Default Place a cell value on Charts

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.