I am automating the preview of MS-Graph in VFP forms and their exports into Excel and PowerPoint.
There are way too many options on the software now to customize the charts (color, font, style, shadow, gradient, ...) and each time I change a property in the graph it has to refresh. So previewing a handful of columns is taking like 5-10 seconds to refresh. If I use other plotters it is done instantaneously.
I read on MSDN and other places that there is a Repaint Property:
However, it seems only to be available in .Net.
I also tried to hide the chart (oChart.Visible = False) and to lock the VFP form from refreshing (LockScreen = .T.) and it improved the performance a bit.
Does anyone know how to handle this? I need to stop MS-Graph from refreshing when I assign all the properties I need.