# DataManipulator Class

**.NET Framework 4.5**

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

System.Object

System.Web.UI.DataVisualization.Charting.DataFormula

System.Web.UI.DataVisualization.Charting.DataManipulator

System.Web.UI.DataVisualization.Charting.DataFormula

System.Web.UI.DataVisualization.Charting.DataManipulator

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

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

The DataManipulator type exposes the following members.

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

FilterMatchedPoints | Gets or sets a value that determines whether points are filtered if they match criteria specified in arguments in the Filter methods of this class. | |

FilterSetEmptyPoints | Gets or sets a flag that indicates whether points filtered by the Filter or FilterTopN methods will be removed or marked as empty. | |

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 | 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(IDataPointFilter, String) | Performs custom filtering on the data points in one or more Series, based on the points in the first series. The filtered Series objects also store the modified data. | |

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(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, 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(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, 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(IDataPointFilter, String, String) | Performs custom filtering on the data points in one or more series, based on the points of the first series. | |

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

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, 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(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(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(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(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. | |

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, 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, 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, Series, Series) | Filters all data points in a series except for a specified number of points with 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, Series, Series, String) | Filters all data points in a series except for a specified number of data points with 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. | |

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. | |

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, String) | Calls a method from a formula module with the specified formula name and input series name(s). (Inherited from DataFormula.) | |

FinancialFormula(FinancialFormula, Series) | Calls a method from a formula module with the specified formula name and input 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, 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, 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.) | |

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.) | |

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

GetType | Gets the Type of the current instance. (Inherited from Object.) | |

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, 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, String, String) | Groups data for one or more series, using one or more formulas. Output series are used to store the grouped 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, 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, 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, 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, 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. | |

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, 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, 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. | |

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. | |

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 interval and intervalType arguments. | |

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 interval and intervalType arguments. | |

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 interval, intervalOffset, intervalOffsetType and intervalType arguments. | |

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 interval, intervalOffset, intervalOffsetType and intervalType arguments. | |

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 interval, intervalOffset, intervalOffsetType and intervalType arguments. The series range that is checked is determined by the toXValue and fromXValue arguments. | |

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 interval, intervalOffset, intervalOffsetType and intervalType arguments. The series range that is checked is determined by the toXValue and fromXValue arguments. | |

MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) | |

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

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

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, 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, 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. | |

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. | |

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

Show: