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

LVL 1
mmeiselAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

spprivateCommented:
You can use OWC for this.

http://www.csharphelp.com/archives2/archive457.html

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;
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
badgerfireCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.