# DataManipulator Class

**.NET Framework (current version)**

Note |
---|

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience. |

Performs data manipulation operations at run time. This class is exposed by the DataManipulator property of the root Chart object.

**Namespace:**System.Web.UI.DataVisualization.Charting

**Assembly:**System.Web.DataVisualization (in System.Web.DataVisualization.dll)

System.Web.UI.DataVisualization.Charting::DataFormula

System.Web.UI.DataVisualization.Charting::DataManipulator

Name | Description | |
---|---|---|

DataManipulator() | Initializes a new instance of the DataManipulator class. |

Name | Description | |
---|---|---|

FilterMatchedPoints | Gets or sets a value that determines whether points are filtered if they match criteria specified in arguments in the | |

FilterSetEmptyPoints | Gets or sets a flag that indicates whether points filtered by the | |

IsEmptyPointIgnored | Gets or sets a flag that indicates whether empty points are ignored while performing calculations.(Inherited from DataFormula.) | |

IsStartFromFirst | Gets or sets a flag that indicates whether to start formulas such as a rolling average from zero.(Inherited from DataFormula.) | |

Statistics | Returns a reference to the StatisticFormula class.(Inherited from DataFormula.) |

Name | Description | |
---|---|---|

CopySeriesValues(String^, String^) | Merges, splits or moves Y values in the series.(Inherited from DataFormula.) | |

Equals(Object^) | Determines whether the specified object is equal to the current object.(Inherited from Object.) | |

ExportSeriesValues() | Exports the data for every series stored in the SeriesCollection to the DataSet object. | |

ExportSeriesValues(Series^) | Exports data from the specified series to the DataSet object. | |

ExportSeriesValues(String^) | Exports data from one or more series to the DataSet object. | |

Filter(CompareMethod, Double, Series^) | Filters data points in a series by applying a filtering rule to the first Y-value of each data point. The Series object that is filtered also stores the modified data. | |

Filter(CompareMethod, Double, Series^, Series^) | Filters the data points in a series by applying a filtering rule to the first Y-value of each of the data points. | |

Filter(CompareMethod, Double, Series^, Series^, String^) | Filters the data points in a series by applying a filtering rule to the specified data point values for comparison. | |

Filter(CompareMethod, Double, String^) | Filters one or more series by applying a filtering rule to the first Y-value of the data points in the first series. The filtered Series objects are used to store the modified data. | |

Filter(CompareMethod, Double, String^, String^) | Filters one or more series by applying a filtering rule to the first Y-value of each of the data points in the first series. | |

Filter(CompareMethod, Double, String^, String^, String^) | Filters one or more series by applying a filtering rule to the specified data point values in the first series. | |

Filter(DateRangeType, String^, Series^) | Filters the data points in a series, either by removing the specified points or by marking them as empty for the specified date/time ranges. The Series object that is filtered is used to store the modified data. | |

Filter(DateRangeType, String^, Series^, Series^) | Filters the data points in a series, either by removing the specified points or by marking them as empty for the given date/time ranges. | |

Filter(DateRangeType, String^, String^) | Filters the data points of one or more series, either by removing the specified points or by marking them as empty for the given date/time ranges. The filtered Series objects are used to store the modified data. | |

Filter(DateRangeType, String^, String^, String^) | Filters the data points for one or more series, by either removing the specified points or by marking them as empty for the given date/time ranges. | |

Filter(IDataPointFilter^, Series^) | Performs custom filtering on the data points in a series. The Series object that is filtered also stores the modified data. | |

Filter(IDataPointFilter^, Series^, Series^) | Performs custom filtering on the data points in a series. | |

Filter(IDataPointFilter^, String^) | ||

Filter(IDataPointFilter^, String^, String^) | Performs custom filtering on the data points in one or more series, based on the points of the first series. | |

FilterTopN(Int32, Series^) | Filters out all data points in a series except for a specified number of points with the largest first Y-values. The Series object that is filtered is used to store the modified data. | |

FilterTopN(Int32, Series^, Series^) | Filters all data points in a series except for a specified number of points with the largest first Y-values. | |

FilterTopN(Int32, Series^, Series^, String^) | Filters all data points in a series except for a specified number of data points with the largest values. | |

FilterTopN(Int32, Series^, Series^, String^, Boolean) | Filters all data points in a series except for a specified number of points with the smallest or largest values. | |

FilterTopN(Int32, String^) | Filters all data points in one or more series except for a specified number of points. The points that are not filtered correspond to points in the first series that have the largest first Y-values. The Series objects that are filtered are used to store the modified data. | |

FilterTopN(Int32, String^, String^) | Filters out data points in one or more series except for a specified number of points. The points that aren't filtered correspond to points in the first series that have the largest first Y-values. | |

FilterTopN(Int32, String^, String^, String^) | Filters all data points in one or more series except for a specified number of data points. The points that are not filtered correspond to points in the first series that have the largest values. | |

FilterTopN(Int32, String^, String^, String^, Boolean) | Filters all data points in one or more series except for a specified number of points. The points that are not filtered correspond to points in the first input series that have the largest or smallest values. | |

Finalize() | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.(Inherited from Object.) | |

FinancialFormula(FinancialFormula, Series^) | Calls a method from a formula module with the specified formula name and input series.(Inherited from DataFormula.) | |

FinancialFormula(FinancialFormula, Series^, Series^) | Calls a method from a formula module with the specified formula name, input series and output series.(Inherited from DataFormula.) | |

FinancialFormula(FinancialFormula, String^) | Calls a method from a formula module with the specified formula name and input series name(s).(Inherited from DataFormula.) | |

FinancialFormula(FinancialFormula, String^, Series^, Series^) | Calls a method from a formula module with the specified formula name, formula parameters, input series and output series.(Inherited from DataFormula.) | |

FinancialFormula(FinancialFormula, String^, String^) | Calls a method from a formula module with the specified formula name, input series name(s) and output series name(s).(Inherited from DataFormula.) | |

FinancialFormula(FinancialFormula, String^, String^, String^) | Calls a method from a formula module with the specified formula name, formula parameters, input series name(s) and output series name(s).(Inherited from DataFormula.) | |

GetHashCode() | Serves as the default hash function. (Inherited from Object.) | |

GetType() | ||

Group(String^, Double, IntervalType, Double, IntervalType, Series^) | Groups data using one or more formulas. The series that is grouped is cleared of its original data, and used to store the new data points. | |

Group(String^, Double, IntervalType, Double, IntervalType, Series^, Series^) | Groups a series using one or more formulas. An output series is used to store the grouped data points, and an offset can be used for intervals. | |

Group(String^, Double, IntervalType, Double, IntervalType, String^) | Groups data for one or more series, using one or more formulas. Series are cleared of their original data and used to store the new data points. | |

Group(String^, Double, IntervalType, Double, IntervalType, String^, String^) | Groups one or more series, using one or more formulas. Output series are used to store the grouped data points, and an offset can be used for intervals. | |

Group(String^, Double, IntervalType, Series^) | Groups data using one or more formulas. The series that is grouped is cleared of its original data, and used to store the new data points. | |

Group(String^, Double, IntervalType, Series^, Series^) | Groups data using one or more formulas. An output series is used to store the grouped data points. | |

Group(String^, Double, IntervalType, String^) | Groups data using one or more formulas, for one or more series. Series are cleared of their original data and used to store the new data points. | |

Group(String^, Double, IntervalType, String^, String^) | Groups data for one or more series, using one or more formulas. Output series are used to store the grouped data points. | |

GroupByAxisLabel(String^, Series^) | Groups data points in a series by axis labels, using one or more formulas. Original data point values are cleared, and the series then stores the new grouped data points. | |

GroupByAxisLabel(String^, Series^, Series^) | Groups the data points in a series by axis labels, using one or more formulas. An output series is used to store the grouped data points. | |

GroupByAxisLabel(String^, String^) | Groups data points from one or more series by axis labels, using one or more formulas. Original data point values are cleared, and each of the series then stores its new grouped data points. | |

GroupByAxisLabel(String^, String^, String^) | Groups the data points in one or more series by axis labels, using one or more formulas. Output series are used to store the grouped data points. | |

InsertEmptyPoints(Double, IntervalType, Double, IntervalType, Double, Double, Series^) | Replaces the missing data points in a series with empty points. The series is checked for a given interval that is determined by the | |

InsertEmptyPoints(Double, IntervalType, Double, IntervalType, Double, Double, String^) | Replaces the missing data points in one or more series with empty points. Each series is checked for a given interval that is determined by the | |

InsertEmptyPoints(Double, IntervalType, Double, IntervalType, Series^) | Replaces the missing data points in a series with empty points. The series is checked for a given interval that is determined by the | |

InsertEmptyPoints(Double, IntervalType, Double, IntervalType, String^) | Replaces the missing data points in one or more series with empty points. Each series is checked for a given interval that is determined by the | |

InsertEmptyPoints(Double, IntervalType, Series^) | Replaces the missing data points in a series with empty points. The series is checked for a given interval that is determined by the | |

InsertEmptyPoints(Double, IntervalType, String^) | Replaces the missing data points in one or more series with empty points. Each series is checked for a given interval that is determined by the | |

MemberwiseClone() | ||

Sort(IComparer<DataPoint^>^, Series^) | Performs a custom sort on the data points in a series. | |

Sort(IComparer<DataPoint^>^, String^) | Performs a custom sort on one or more series. | |

Sort(PointSortOrder, Series^) | Performs a sort on the data points in a series using the specified order. The sort is based on the first Y-value of each of the data points. | |

Sort(PointSortOrder, String^) | Performs a sort on the data points in one or more series, using the specified order. The sort is based on the first Y-value of each of the data points. | |

Sort(PointSortOrder, String^, Series^) | Performs a sort on the data points in a series using the specified order. The sort can be based on any available data point value. | |

Sort(PointSortOrder, String^, String^) | Sorts the data points of one or more series in the specified order. The sort can be based on any available data point value. | |

ToString() | Returns a string that represents the current object.(Inherited from Object.) |

**.NET Framework**

Available since 4.0

Any public static (
**Shared**
in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.