series object manages the values of a series of data that is displayed in a chart. The set of series objects is accessed from the chart's .seriesCollection property. .axisGroup whose value is either xlPrimary or xlSecondary. series object include name | The name of a series might be specified in the first argument of the series() function (see .formula property) |
values | |
xvalues | Either a range or an array of values |
type | set to a constant such as xlColumn, xlBar etc, see below. |
charttype | an element of the xlChartType enumeration. This value seems to be especially interesting if the series object is used in a combo chart where multiple chart types are represented by the series objects. |
formula | =series(…). |
formula property is assigned a =series(…) function. This function is special because it can only be used for charts, not in worksheets. series() function and its arguments is shown in the formula bar. series() formula. =series() function are =series( name , x_values , values , plot_order, bubble_size )
name specifies the name of the series. If this parameter is not specifed, a default name like Series1 will be used. x_values specifies the category values. If this parameter is not used, the values 1, 2, 3 … will be chosen. x_values. values specifies the values of the series. bubble_size is optional x_values and values can either be specified with a range notation (that always seems to include the worksheet name) or a hard coded set of values with a curly-braces notation: =series(… , { 17, 23, 19 }, … )
type property can be set to one of the following constants: xlColumn | 3 |
xlBar | 2 |
xl3DBar | -4099 |
xlLine | 4 |
xlPie | 5 |
xlXYScatter | -4169 |
xlArea | 1 |
xl3DArea | -4098 |
xlDoughnut | -4120 |
xlRadar | -4151 |
xl3DSurface | -4103 |
xl3DColumn | -4100 |
xl3DBar | -4099 |