Using MSChart control

[Brezhnev]

Hi all!
I am using MSChart Activex created by Mike Lewis ...
I modified it greatly for my own needs , but overall it's a great class to play with.
Have still some problems :
1. would like to be able to print to Word and Excel... Managed to write code to lunch and paste to Word.Can anybody help me with Excel ?

2. how can I decide on resolution ? how can I define myself value limits on axis (i understand that it does it for me depending on the values in the cursor?)?

3. why 3d charts so much smaller .. can I regulate overall size myself ?

thanks a lot for any help

 

[Brezhnev]

Hi again!
Still playing with MSChart class (SimpleChart)... One of the main problems I have -- values on Y-axis are not clear for the user. I set programmatically maximum and minimum:

(SELECT MAX(Amount1) AS MaxAmount;
FROM csrTest;
INTO CURSOR csrMax

WITH THIS.PrintChart.Plot.Axis(1).ValueScale
.Auto = .F.
.Minimum = 0
.Maximum = csrMax.MaxAmount
ENDWITH)

, but can't see how I can see values in-between??? Second of all , to set Maximum and Minimum I need to set .Auto to .F. , but this way I see no horizontal scale.
Can anybody help?