I am using Excel 2003 to display an XY plot on a chart. The plot updates
continuously to display real-time information to an equipment operator. The
chart data series, on another sheet, receive their information continuously,
twice a second, through a DDE connection. Whenever the chart updates, the
chart has an annoying flicker. (The chart might be displaying a white
background, then re-displaying the updated plots). Curiously, a textbox on
the chart also updates some real-time data. Rather than flickering, the data
simply changes in the textbox.
I would hope that the plot could be made to similarly update its pixels
without flickering the whole chart.