Data can be manipulated by:
Microsoft Chart Control for .NET Framework provides two types of formulas: financial and statistical.
The Chart control provides over thirty technical analysis formulas, such as moving averages, price indicators, volume indicators, oscillators, and forecasting 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 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).
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.
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:
Data binding. Saving into the file or stream. Converting to a different format, like XML. Editing.
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.
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.