VSTO & .NET & Excel

September 2, 2009

Microsoft Chart Control for .NET

Filed under: .NET & Excel, Charts components, VSTO & Excel — Dennis M Wallentin @ 10:39 am

In 2007 Microsoft aquired Dundas Data Visualization but Dundas still remains as a standalone company. What matters is that by acquiring Dundas Microsoft got access to all the Dundas .NET controls. Last year Microsoft made the Chart control available for free. Originally the Chart control comes from Dundas but  Microsoft has done an update of its code base so it fits better with Visual Studio.

So far Microsoft have only provided some basic controls in Visual Studio and has let other providers to provide more advanced commercial controls. But with the Chart control they make an exception and provide an excellent control for free. Perhaps we will see more of that in the future?

I find the Chart control to be a great companion into my solutions where it requires some data presentation in terms of charts. Due to this I believe it deserves to be more highlighted within the Excel and .NET developing communities.

 Initially I planned to create a sample and discuss it in more detail however because MSFT has made over 200 samples available there are no reasons why I just should repeat some of these samples here. Actually, the sample collection is very nice and all the code samples can be viewed in both C# and VB.NET as the below screen shot shows.

Samples

What should be noted is that we cannot place the control on worksheets when creating document centric VSTO solutions. But on the other hand we don’t need to use it like that as we have access to Excel’s nice built-in chart control.

 For more information and to download please see the following links:

A great blog about the Chart control is Alex Gorev’s Weblog.

Kind regards,
Dennis

Advertisements

2 Comments »

  1. Hi Dennis,

    Thanks for the excellent intro on the Microsoft Chart Controls. I experimented with these a while ago, when they first came out and found them to be very nice controls to use and they look good.

    They also have a huge number of settings. This is good because it gives a tremendous amount of control over the layout, but it’s also pretty overwhelming initially.

    Thanks for citing all the resources — those are really good links to get started. Hopefully I’ll have the time to look over those 200+ samples…

    — Mike

    Comment by Mike Rosenblum — September 5, 2009 @ 4:43 pm

    • Mike,

      Thanks for Your kind words. I would say that a larger number of properties we can manipulate for a control is typical for commercial controls. The connection between MSFT and Dundas seems here to be a good situation 🙂

      Kind regards,
      Dennis

      Comment by Dennis Wallentin — September 6, 2009 @ 10:50 am


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: