Contains the definition of a data series in a chart that is based on data from a cell table.
Contained In
Subelements
3DBubble, Border, BubbleSize, Caption, Category, Close, DataLabels, DataPoint, ErrorBars, Explode, High, Index, Interior, Line, Low, Marker, Name, Open, Shape, Smooth, Trendline, UpDownBars, Value, XValue, YValue
Remarks
This element can contain one or more Category subelements depending on the type of chart. Whether a subelement is required depends on the type of chart. If one is specified that is not appropriate for a particular type, it is ignored.
Type of Chart | Optional Subelements |
Line | Smooth and UpDownBars |
Scatter | SecondaryAxis and Smooth |
Stock | UpDownBars |
The BubbleSize, Caption, Category, Close, High, Low, Open, Value, XValue, and YValue subelements contain either a string or subelements depending on whether the chart was saved from Microsoft Excel or the Chart component. For Excel, these subelements contain an A1-style cell reference or a literal data string such as {1, 2, 3,...}
, {"a", "b", "c",...}
, or apples
. For the Chart component, these subelements contain the Data and DataSource subelements.
Whether the Border and Line subelements can be specified depends on the type of chart as shown in the following table.
If the type of chart is | the Border subelement | the Line subelement |
Area | specifies the formatting of the outline. | is not specified. |
Bar or Column | specifies the formatting of the bar or column's border. | specifies the formatting of the series line, if visible. A Line subelement is specified for each series. When the Web page is opened in Microsoft Excel, the SubType subelement specifies a stacked or 100% stacked chart, and the Line subelement is specified for several series, the formatting specified in the first Line subelement is used to format all series lines in the chart. |
Bubble | specifies the formatting of each bubble's outline. | specifies the formatting of lines for bubble charts that have lines. |
Doughnut or Pie | specifies the formatting of each slice's outline. | is not specified. |
Line | specifies the formatting of 3-D line chart outlines. | specifies the formatting of lines. |
Radar | is not specified. | specifies the formatting of lines. |
Stock High/Low/Close | is not specified. | specifies the formatting of the high and low line. |
Stock Open/High/Low/Close | is not specified. | specifies the formatting of the open and close line. The UpDownBars subelement specifies the formatting of the up-down bars. |
Surface | specifies the formatting of the outline. | is not specified. |
XY (Scatter) | is not specified. | specifies the formatting of lines for scatter charts that have lines. |
See the example in the WebChart element topic.