get 24 hour data before creating chart. put columnrange first in series array or dynamic update won't work properly. got auto update to work.
change update interval to once a minute.