ARTICLE

WPF Column Chart in VB.NET

Posted by Dinesh Beniwal Articles | WPF using VB.NET February 10, 2010
This article demonstrates how to draw column charts using WPF and VB.NET
 
Reader Level:

The WPF Toolkit released in June 2009 comes with a data visualization assembly called System.Windows.Controls.DataVisualization.Toolkit.dll that hosts the charting functionality in WPF.  This article demonstrates how to draw column charts using the WPF Toolkit.

Note: This article is written by using the WPF Toolkit June 2009 that you can download from here: WPF Toolkit - Release: WPF Toolkit June 2009. This toolkit may be a part of WPF in near future versions.

Adding WPF Toolkit Reference

Before you can use any charting related functionality in a WPF application, you must download the WPF Toolkit. After that you need to add a reference to an assembly.

To add a reference, right click the References folder of your project in Solution Explorer and select Add Reference. This action will open the Add Reference dialog as you can in the following Figure 1. On this dialog, select Browse option and browse the System.Windows.Controls.DataVisualization.Toolkit.dll assembly from the folder where you installed the WPF Toolkit. This assembly resides in the Binaries folder.

Tip: If you do not want to download WPF Toolkit, you can download the attached project and copy WPFToolkit.dll and System.Windows.Controls.DataVisualization.Toolkit.dll assemblies from this project to the bin folder of your project and add reference.

AreaChartImg1.gif

Figure 1

Once you add the reference, you will see the System.Windows.Controls.DataVisualization.Toolkit added to your References dialog as you see in Figure 2.

AreaChartImg2.gif

Figure 2

Now, the next step is to import the System.Windows.Controls.DataVisualization.toolkit and the System.Windows.Controls.DataVisualization.Charting namespaces to the page.  Once you type xmlns= in your page, you will see these namespaces in the Intellisense. Select and add both of them to your page as you can see in Figure 3.

AreaChartImg3.gif

Figure 3

The final reference added to the page looks like following. As you can see here, I added name of this reference to ToolkitRef.

  xmlns:DV="clr-namespace:System.Windows.Controls.DataVisualization;assembly=System.Windows.Controls.DataVisualization.Toolkit"
        xmlns:DVC="clr-namespace:System.Windows.Controls.DataVisualization.Charting;assembly=System.Windows.Controls.DataVisualization.Toolkit"

Now you will see DVC in your page and once you select it, you will notice all Charting related elements added to the Intellisense. To add a Chart control to your page, just select the Chart control from the list. The list of charting related elements looks like Figure 4.

AreaChartImg4.gif

Figure 4

Creating a Chart

The Chart element represents a WPF Chart control in XAML.

< DVC:Chart></DVC:Chart>

The code snippet in Listing 1 creates a Chart and sets its width, height, and background properties of the Chart control. The Title and LegendTitle properties represent the title of the chart and the title of legend.

<DVC:Chart Name="mcChart"
           Width="400" Height="250"
           Background="YellowGreen"
                   Foreground="DarkBlue"
                   Title="Area Chart"
                   LegendTitle="Month Rating" />

Listing 1

The output of Listing 1 looks like Figure 5.

AreaChartImg5.gif

Figure 5

Chart Types

The Series attribute of the Chart element is used to create a chart type. If you see in Figure 6, you will notice BarSeries, ColumnSeries, LineSeries, PieSeries, AreaSeries and ScatterSeries attributes and based on the attribute, the chart will be created.

AreaChartImg6.gif
 

Figure 6

Column Chart

The code snippet in Listing 2 creates a column chart by setting Chart.Series to ColumnSeries. As you may see, the binding is occurred on Key and Value fields of a data source.

<DVC:Chart Canvas.Top="80" Canvas.Left="10" Name="mcChart"
   Width="400" Height="250"
   Background="LightSteelBlue">

    <DVC:Chart.Series>
        <DVC:ColumnSeries Title="Experience"
            IndependentValueBinding="{Binding Path=Key}"
            DependentValueBinding="{Binding Path=Value}">
        </DVC:ColumnSeries>
    </DVC:Chart.Series>
</
DVC:Chart>           

Listing 2

The code snippet in Listing 3 creates a collection in KeyValuePair form and sets the ItemsSource property of the chart series. Same data can be used for other chart types.

    Private Sub LoadColumnChartData()
        DirectCast(mcChart.Series(0), ColumnSeries).ItemsSource = New KeyValuePair(Of String, Integer)() {New KeyValuePair(Of String, Integer)("Project Manager", 12), New KeyValuePair(Of String, Integer)("CEO", 25), New KeyValuePair(Of String, Integer)("Software Engg.", 5), New KeyValuePair(Of String, Integer)("Team Leader", 6), New KeyValuePair(Of String, Integer)("Project Leader", 10), New KeyValuePair(Of String, Integer)("Developer", 4)}
    End Sub

Listing 3

The output looks like Figure 7.

AreaChartImg7.gif
Figure 7

Summary

This tutorial discusses how to use WPF Toolkit to create a column chart in WPF and VB.NET.

Login to add your contents and source code to this article
Article Extensions
Contents added by kashan khan on Mar 31, 2010
thankx
share this article :
post comment
 

Hi Friends, I am getting stuck with this.. I am using RichTextBox for retriving data(column) into that, then Running several time of Regex replace operation then updating the database. But this taking so much time mainly retriving data column from database and also update the database with that. (Regex operation is running fine /fast). i am thinking Richtextbox creating problem as tool. can you guys help me over that. which textbox or which tool i should use for this operation. please help me in urgent way on this. -Alok

Posted by alok singh Feb 03, 2011
Nevron Diagram
Become a Sponsor
PREMIUM SPONSORS
  • The leading .NET charting control now features PDF, Flash and Silverlight export, visualization of large datasets and more. Deliver true charting functionality to your BI, Scorecard, Presentation or Scientific apps. Download evaluation now.
    The leading .NET charting control now features PDF, Flash and Silverlight export, visualization of large datasets and more. Deliver true charting functionality to your BI, Scorecard, Presentation or Scientific apps. Download evaluation now.
Team Foundation Server Hosting
Become a Sponsor