Dynamic charting
 

Hi

I have some charts that update automatically. Recently I have changed
the formula in the field that gets charted from =e45/f45*100 to one
that reflects the percentage being as a target towards 100% accuracy
so if the actual was 103% then 97% would be displayed. The charts have
stopped automatically updating. Could you please help.

Cheers

Brian

Dynamic charting
 

1) has automatic recalc been sent to manual
2) are you sure that the new formula is returning a different value. The
chart will not look different if it returns the same value as the prior
function


" wrote:

Hi

I have some charts that update automatically. Recently I have changed
the formula in the field that gets charted from =e45/f45*100 to one
that reflects the percentage being as a target towards 100% accuracy
so if the actual was 103% then 97% would be displayed. The charts have
stopped automatically updating. Could you please help.

Cheers

Brian