Thread: GRAPHS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default GRAPHS

Replace the empty call by =NA() which displays as #N/A and is ignored by
chart engine. Then as each new data arrive replace =NA() by new data and
chart will update
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"svangis" wrote in message
...
Hello

If I do a a graphs for let say 12 months. I only got values for half of
the
time but there are formula in the all. THe first week there are no values
the
curv is dying, why and what can I do so I have an automatic refresh of the
graph.
yours
svängis