Data can be manipulated by:

Using Formulas

Microsoft Chart Control for .NET Framework provides two types of formulas: financial and statistical.

Financial Formulas

The Chart control provides over thirty technical analysis formulas, such as moving averages, price indicators, volume indicators, oscillators, and forecasting formulas.

Statistical Formulas

Statistical formulas in the Chart control can be organized into four general groups: statistical tests, statistical distributions, basic statistical functions and utility functions.

Splitting, Copying, and Merging

Splitting refers to the copying of multiple Y values from a single source series to multiple destination series. The figure on the left shows a Bubble chart, which plots two Y values in a single series. The data is split into two different series and plotted in the figure on the right, and each series is plotted using a different chart type (Column and Line).

Filtering DataFiltering Data

Merging refers to copying values from multiple source series to populate one destination series. In other words, it is the reverse of data splitting.

Copying refers to all other copy operations.

Exporting Series

When a series is exported, the X and Y values of all data points in the series are persisted in an in-memory cache, where they can be used for:

Filtering Series

Data is filtered on a series-by-series basis. When a series is filtered, its data points are either removed from the series or marked as empty. The points that are filtered depends on the specified filtering criteria.

Filtering allows for the display of only useful data to chart readers. The figure below shows data points below the value of 400 removed after the series is filtered.

Filtering Data

Grouping Series

Grouping replaces a sequence of data points in a series with one grouped point. The X and Y values of each grouped point are calculated using a specified formula and the original points' values.

Grouping is especially useful when a large data set makes it difficult to spot trends in a chart.