Solved

MS Chart Controls

Posted on 2009-07-09
3
361 Views
Last Modified: 2012-05-07
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

0
Comment
Question by:mmeisel
3 Comments
 
LVL 15

Accepted Solution

by:
spprivate earned 250 total points
Comment Utility
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
 
LVL 2

Expert Comment

by:badgerfire
Comment Utility
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

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

AJAX ModalPopupExtender has a required property "TargetControlID" which may seem to be very confusing to new users. It means the server control that will be extended by the ModalPopup, for instance, if when you click a button, a ModalPopup displays,…
Lots of people ask this question on how to extend the “MembershipProvider” to make use of custom authentication like using existing database or make use of some other way of authentication. Many blogs show you how to extend the membership provider c…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now