Solved

MS Chart Controls

Posted on 2009-07-09
3
366 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
ID: 24815054
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
ID: 25018220
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
asp day pilot 3 23
ASP.NET MVC identity 6 30
ASP.NET MVC -Add authentication 2 29
Older JQuery functionality is not in the newer JQuery 1.4.4 versions, 6 38
ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

808 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