>Can you do a Gantt chart using the MSCHART control? It's listed as a valid ChartType, but it says invalid if you try to select it. It list 28 different chart types (0-27), but you can only select 0-9,14,16 as valid types.
>
>Any clues?


Try using Excel with macro recording turned on and look in the macro code to see what the value is. The values for the charts are for some (Microsoft) reason not 0 - 27 as one would think. Without looking at the code, if I recall correctly I have one chart that is of type -4203.

Good Luck