How do I create a smooth line graph instead of absolute values? And also, how do I set the values for the Y axis. For example, I want the y axis to go from 10,000 to -10,000 incremented by 1000. Thanks

'absolute value' means the positive of any negative number. the ABS(-1)=1, for ex.
so perhaps you mean trend line, the way you can get excel to calculate the trend line for you ; alas, i think you have to create the trend line first yourself. as for the graph styling, if you do a search on this board for posts from 'JG' (member# 1224), he has answered those questions for me and for others; he's the graph whizkid! You'll learn alot from reading him.

I searched and did not see anything about setting the values of and increments for the y axis. If he has answered this for you woulod you mindtelling me how to do it.

Here are some of the commands:
for increments:
setGridStep(getY1MajorGrid(),10000);
setGridStepAuto(getY1MajorGrid(),false);
for top of scale:
setScaleMax(getY1Axis(),1000);
setScaleMaxAuto(getY1Axis(),false);
for bottom of scale
setScaleMinAuto(getY1Axis(),false);
setScaleMin(getY1Axis(),-10000);