MS Chart Controls

I'm fairly new to MS Chart Controls and am having a difficult time.  I'd like to be able to dynamically change the Chart Type based on a drop down list (i.e. Pie, bar, etc.).  Can anyone provide any insight on how to go about this?

I downloaded the WebSamples from MS but they don't seem to help.  See the code below.  Intellisense isn't picking up the Type property of Series.

Or better yet, does anyone have any alternate reporting methods for charts and graphs besides MS Charts?
' Set series chart type
Chart1.Series("Default").Type = SeriesChartType.Bar

Open in new window

Who is Participating?
spprivateConnect With a Mentor Commented:
You can use OWC for this.

I have used this and it is pretty,but havent tried to change it dynamically.

This line is where you need to set the property for the chart type
objChart.Type = OWC.ChartChartTypeEnum.chChartTypeColumnClustered;
Calling a chart objkect on an access form

Me.chtTEST.ChartType = xlLine  ' Line Chart

Me.chtTEST.ChartType = xlPie 'Pie Chart

Me.chtTEST.ChartType = xl3DPie '3d Pie chart

Be aware that not all chart types share the same types of parameters.

A list of constants can be found under the object browser in the visual basic editor in Access
The library is graph.

I would love to tell you there is a lot of information on this but it's more trial and error when programming graph and even OWC.  The saving grace is that you can record macros in excel when modifying charts and the code is almost a one for one in VBA.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.