Can form useMicrosoft Excel Chart instead of Microsoft Chart Wizard

[matakulous]

Hi all,

I'm trying to create a chart in a form, this is not a problem, however, the chart types available are a bit limited compared to if i inserted a Microsoft Excel Chart object.

I'd do that except I'm trying to create a chart based on a query.

Is there a way to make the chart wizard use the Microsoft Excel Chart object as its chart creator so I have access to the chart types available in that object?

any assistance much appreciated.

thanks all.

regards

keji

 

[matakulous]

never mind all,

i feel really duh right now.

so i created the chart and once its on the form, i then right click and wah laaa! there it is, i can select the chart type and its got all this charty goodness available to me.

thanks anyway all!

regards

Keji