For data validation, specifies the range, value, or list of values that the input data is validated against. For display units, specifies the unit label of an axis. For an error bar, specifies the fixed value, percentage, or standard deviation if the ErrorType element contains one of these types of error bars. For a series, specifies the values or a range of cells that a series uses as values in a chart. For a trendline, contains the order of a polynomial in a polynomial trendline, or the period over which to calculate a moving average trendline.
Contained In
DataValidation,
DisplayUnits,
ErrorBars,
Trendline,
Series
Subelements
For the Chart component: Data, DataSource
Remarks
For data validation, this element contains a text string that specifies one or more values, a formula, or a cell range in A1-style.
To specify a formula, you must start the formula with an equal sign (=), but to specify a list of values, you must start and end the list with ".
For display units, the Value element contains one of the following string constants specifying the unit: Hundreds, Thousands, TenThousands, HundredThousands, Millions, TenMillions, HundredMillions, Billions, Trillions. The default unit is None, specifying no units displayed. This element can also contain a number specifying a custom unit. For example, if you plot distances in feet and specify 5280 in the DisplayUnits element, the chart displays the distance in miles (5280 feet per mile).
For a series, the numbers are typically plotted along a value (y) axis, except in charts such as pie charts that do not have a value axis.
This element contains either a string or subelements depending on whether the chart was saved from Microsoft Excel or the Chart component.
For Excel, this element contains an A1-style cell reference or a literal data string such as {1, 2, 3,...}, {"a", "b", "c",...}, or apples.
For the Chart component, the Data and DataSource subelements are required.
For a polynomial trendline, a value of 2, for example, would solve an equation of the form y = ax2 + bx + c. For a moving average trendline, the value represents the period over which to calculate the average. For both types of trendline, the minimum value is 2.
See the examples in the DataValidation and WebChart element topics.