GRAPHS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loose formula/value (when building graphs) 3
Access Combination Chart Types Access 2010 0
Reference(s) to worksheets for building graphs 4
calculating the area under a curve for graphs in Microsoft Excel 0
If data present, then display graph. 2
Get value equal to final point of chart trendline [=Trend( )] ? 1
Graphs Axes Location 2
Error in graph 8

Back
Top