>>
>>Excellent code! Cetin, where I can find a list of all graph properties (to modify graph on fly).
>VBA_grp.hlp (..\msapps\msgraph5)or vbagrp8.hlp (..\Microsoft office\Office). I "steal" the PEM from there. Again hlp is for VB (as M$ always do) and the real trouble is VB constants. I couldn't find a reference for those constants yet.
>BTW: autoformat(14, 1) works with MSGraph5 but I think they've changed the VB constants for MSGraph8. I built a simple form (above is init code with of course 10 instead of 2000) and there I have 2 textboxes feeding autoformat values to graph. autoformat(-1 to 5,1) works ! No documentation for autoformat in vbgrp8.hlp.
>Do you know a way to reveal out (or pass as Constant name) those constants ?
>Cetin

GraphType Constants

Constant Value Description

gphNone 0 No graph.
gphPie2d 1 Two-dimensional pie chart.
gphPie3d 2 Three-dimensional pie chart.
gphBar2d 3 Two-dimensional bar chart.
gphBar3d 4 Three-dimensional bar chart.

If this is what you need, it's in the VB.hlp, just find "Visual Basic Custom Control Constants" in it. Ridiculous as it always seems, sometimes it helps to look at the Contents page, though the M$'s way of writing help files is normally (99% cases) a real frustration to search. Sometimes I wish I had to use those things for what M$ intended them for, and not for what I need :)