We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Overview

The WinForms Pivot Chart control organizes and summarizes business data and displays the result in a graphical format.

Windows Forms pivot chart control


Relational data source binding in Windows Forms pivot chart control

Data binding

The WinForms Pivot Chart control simulates the pivot chart feature of Excel. The data source for the control should be a DataTable, DataView, or DataSet from SQL databases or collections like IEnumerable, ICollection, IList, List, and ArrayList.


Chart types

The WinForms Pivot Chart control allows users to visualize data using these different chart types: line, spline, column, area, spline area, stacking area, stacking column, 100% stacking area, 100% stacking column, step line, and step area. Each one is highly and easily configurable with built-in support for creating stunning visual effects. Users can easily switch among different chart types dynamically.

Types of charts supported in Windows Forms pivot chart control


Pivot table field list and group fields

The pivot table field list and group fields are automatically populated with fields from the bound data source. They then allow end users to drag fields, filter and sort them, and create a pivot report at runtime.

Field list support in Windows Forms pivot chart control for creating reports dynamically at runtime


Drill up functionality in Windows Forms pivot chart control

Drill down and drill up

There is built-in support to drill down (expand) and drill up (collapse) to visualize the pivot information in both abstract and detailed views.


Defer update

Refresh the control only on demand and not during every UI interaction.

Defer update support in Windows Forms pivot chart control


Real-time update in Windows Forms pivot chart control

Real-time update

Update the series values in real time by pushing the live data and refreshing the chart area whenever it’s required.


Filtering

Display only selective values for a field through either UI or code-behind.

Filtering support in Windows Forms pivot chart control


Sorting support in Windows Forms pivot chart control

Sorting

Order the column and row header text based on the custom comparer defined by user.


Summaries and calculations

Summaries support in WinForms Pivot Chart control

Summaries

Define your own custom summaries or use 10 built-in summary types.

Calculation support in WinForms Pivot Chart control

Calculations

Insert new calculations or use one of 16 built-in calculation types.


Calculated field

A calculated field, otherwise known as an unbound field, generates a unique field with your own calculated values by executing a simple, user-defined formula.

Calculated field support in WinForms pivot chart control


Expression field support in WinForms pivot chart control

Expression field

Expression fields generate data by executing a user-defined expression. The generated data is specific to a few fields from the underlying data source.


Legend

A color code helps to differentiate between chart series items. A legend has labels beside each color to present some detail about the series.

Identifies chart labels through legend in Windows Forms pivot chart control


Axes and series

Series customization support in Windows Forms pivot chart control

Series customization

Customize the series color, border color, and border width of the control.

Data labels in Windows Forms pivot chart control

Data labels

Data labels provide information about a data point with the help of adornments in series.

Axis labels in Windows Forms pivot chart control

Axis labels

Customization options for the axis labels include positioning, placement, label format, and rotation. There are also options for avoiding labels overlapping.

Chart palettes in Windows Forms pivot chart control

Chart palettes

The control comes with a set of color palettes that are automatically applied to a chart’s data points if no custom colors are specified for the series. These built-in palettes offer a rich set of colors to render professional-looking charts.

Title in Windows Forms pivot chart control

Titles

Titles provide captions for the chart and chart axes, describing the control’s actual purpose in an application.

Watermark support in Windows Forms pivot chart control

Watermarks

Watermarks provide faint imprints on the chart that can be either images or text.


User interaction

Marker and cross hair support in Windows Forms pivot chart control

Marker and crosshair

Markers are symbolic representations of points in the control. Crosshair will return the exact data for the X and Y coordinates under the pointer.

Zooming support in Windows Forms pivot chart control

Zooming and scrolling

Users can take a close look at a data point plotted in the series at runtime with the zooming feature. Once any part of the chart area is zoomed in, scroll bars will automatically appear to let the user view areas beyond the currently displayed chart area.

Tooltip support in Windows Forms pivot chart control

Tooltip

Tooltip provide basic information about a series while hovering the pointer over it.


Exporting and printing

The WinForms Pivot Chart can be exported to an Excel document. A printing option is also available.

Exporting to Excel support in Windows Forms pivot chart control


Custom style and themes

Built-in themes support in Windows Forms pivot chart control

Built-in themes

Ships with built-in themes like Office 2016 and Metro.

Custom style support in Windows Forms pivot chart control

Custom style

Customize the appearance of the control to any extent in code behind.


Globalization and localization

Globalization support in Windows Forms pivot chart control

Globalization

Users from different locales can use the control by applying a date format, currency format, and number format to suit local preferences.

RTL support in Windows Forms pivot chart control

Right-to-left (RTL)

The text direction and layout of the control can be displayed in the right-to-left (RTL) direction.

Localization support in Windows Forms pivot chart control

Localization

Allows users to customize the text in the user interface based on the local culture.


100+ WINDOWS FORMS CONTROLS

Transform your applications today by downloading our free evaluation versionDownload Free Trial

Scroll up icon

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon