[5.2.6] calc charts do not update

users
#1

It is a real nightmare: I cannot find why sometimes charts
automatically update and sometimes they don't.
In particular, I have a series that sometimes has some points,
sometimes not and very often, when later I add some new values to an
empty series, the chart do not show the new point. That's very
disturbing. I would be happy to have a macro function to apply to the
graphs so that I can update them but I cannot find any "refresh"
command.
I noticed that if I print the sheet in a pdf doc, the point appear but
not before! Previewing is not enough.

Regards,

Frédéric

#2

I'm guessing, but have you tried Tools | Cell Content > | Recalculate (or
F9) or Ctrl+Shift+F9 (Recalculate Hard)?

This doesn't help.

A colleague found that that hiding then unhiding the rows that are
below the charts solves the issue. Note that these rows are not the
ones that contain the data to be plotted. Let's see if this strange
method works for more than 1 night!

Frédéric