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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Overview

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

UWP pivot chart control


UWP pivot chart control

Data binding

The UWP Pivot Chart control simulates the pivot chart feature of Excel. The data source for the control should be either OLAP or pivot data sources:

  • OLAP data sources: SSAS, Mondrian, Active Pivot, and Oracle.
  • Pivot data sources: DataTable, DataView, DataSet from SQL databases and collections like IEnumerable, ICollection, IList, List, and ArrayList.

Optimized for mobile devices

Touch support in UWP pivot chart control

Touch support

All features will work on touch devices with ease. Features such as drill up, drill down, and other chart interactions can be done on the fly.

Responsive support in UWP pivot chart control

Responsive support

Responsive support allows the control layout to be viewed on mobile devices.


OLAP

End users can easily slice and dice the OLAP cube elements of their choice to visualize performance, trends, outliers, and more.

Slice and dice support in UWP pivot chart control

Slice and dice

With slice and dice, you can create a new view for end users by selecting dimensions and measures from the data source OLAP cube and filtering them.

Key performance indicators support in UWP pivot chart control

KPIs

KPIs are a collection of calculations associated with a measure group that evaluates business success.

Paging support in UWP pivot chart control

Paging

Extensive support has been provided to load and render large amounts of data through paging or virtual scrolling without any performance constraints.

Named sets support in UWP pivot chart control

Named sets

Named sets simplify MDX queries and provide useful aliases for complex, commonly used set expressions.

Calculated members and measures support in UWP pivot chart control

Calculated members and measures

You can create and display dimensions and measures on your own.


UWP pivot chart control rendered as stacking column 100

Chart types

The UWP Pivot Chart control allows users to visualize data using different chart types: stacked area, spline area, step line area, stacked bar, 100% stacked bar, stacked column, 100% stacked column, spline, step line, scatter, and pie charts. 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.


Drill down and drill up

Drill down (expand) and drill up (collapse) to visualize the pivot information in both abstract and detailed views.

Drill up/drill down functionality in UWP pivot chart control


Filtering support in UWP pivot chart control

Filtering

Easily filter and visualize data in a chart with the built-in filter option.


Sorting

Order series based on values. You can do this only for pivot data sources.

Sorting support in UWP pivot chart control


Summaries and calculations

Summaries support in UWP Pivot Chart control

Summaries

Define your own custom summaries or use 10 built-in summary types. You can do this only for pivot data sources.

Calculation support in UWP Pivot Chart control

Calculations

Insert new calculations and use 16 built-in calculation types. You can do this only for pivot data sources.


Calculated field support in UWP pivot chart control

Calculated field

A calculated field, otherwise known as an unbound field, generates a unique field with our own calculated value by executing a simple user-defined formula. You can use this only for pivot data sources.


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. You can use this only for pivot data sources.

Expression field support in UWP pivot chart control


Legend

A color code helps differentiate chart series items. Legends have labels beside each color to present some detail about the series.

Identifies chart labels through legend in UWP pivot chart control


Axes and series

Series customization support in UWP pivot chart control

Series customization

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

Data labels in UWP pivot chart control

Data labels

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

Axis labels in UWP 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 palette in UWP pivot chart control

Chart palette

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.

Animation in UWP pivot chart control

Animation

Chart series can be animated while rendering and refreshing the control.

Title in UWP pivot chart control

Title

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

Watermark support in UWP pivot chart control

Watermark

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


Annotations

Display metadata about a chart or series at specific points of interest in the plotting area.

Annotations support in UWP pivot chart control


User interaction

Interaction features like zooming, panning, marker, crosshair, and tooltip are supported for better user experience in UWP Pivot Chart.

Marker and cross hair support in UWP pivot chart control

Marker and cross hair

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

Zooming support in UWP pivot chart control

Zooming and scrolling

Users can take a close look at a data point plotted in a 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.

Panning support in UWP pivot chart control

Panning

Users can click and drag the pointer across a zoomed-in chart to navigate to other data points for better viewing.

Tooltip support in UWP pivot chart control

Tooltip

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


Save and load reports in UWP pivot chart control

Save and load reports

Settings in the UWP Pivot Chart control can be serialized to an XML format and loaded back through the built-in deserialization options. You can use this only for pivot data sources.


Exporting

The UWP Pivot Chart can be exported to Word, PDF, and image formats like SVG, PNG, and JPEG.

Exporting to Excel support in Windows Forms pivot chart control


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

Users can customize the text available in the user interface based on the local culture.


Custom style and themes

Built-in themes support in Windows Forms pivot chart control

Built-in themes

The UWP Pivot Chart ships with built-in themes like Blend, Office 2010, Office 2016, Office 365, Visual Studio 2013, Visual Studio 2015, Metro, Lime, and Saffron.

Custom style support in Windows Forms pivot chart control

Custom style

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


70+ UWP 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