Specifies all the series captions from data encoded in a separator-delimited string.

object.SetSeriesCaptionsFromString captions

Arguments

object: Required. A Chart object.
captions: Required. A string that specifies the series captions (see SetSeparators).

Remarks

By default, a new data series added to a chart has no caption.

If some series do not exist, they are created only if the corresponding caption is not empty.

You can set the series captions in a chart with captions encoded in a string (i.e. the captions argument). The string must be formatted as a list of captions, two consecutive captions must be separated by a separator character that can be specified with the SetSeparators method.

Here is an example of series captions encoded in a string with the character ";" as separator.

myEncodedString= "Year 2006;Year 2007"

The string argument captions is parsed by the chart object according to the separator characters specified to the chart object (see the SetSeparators method for specifying separator characters and rules).

The ";" character is the default separator character.

VBScript Sample Code

The following VBScript code shows how to specify the series captions corresponding to the table below using the SetSeriesCaptionsFromString method. This table has two series with captions "Year 2006" and "Year 2007". The categories are "North America", "South America", "Europe", "Middle East" and "Asia".

	North America	South America	Europe	Middle East	Asia
Year 2006	12	7.5	11.3	9.2	5.3
Year 2007	14	9.9	13.1	11.5	4.9

'Let's build the series and categories string with ";" as separator
sep= ";"
ignoremultseparators= true

'Before setting the series and categories, we must specify the separators
chart.SetSeparators sep, ignoremultseparators

myString= "North America" & sep & "South America" & sep & "Europe" & sep & "Middle East" & sep & "Asia"

'Fill the chart with the categories stored in the myString variable
chart.SetCategoriesFromString myString

'Add the first series "Year 2006"
myString= "12" & sep & "7.5" & sep & "11.3" & sep & "9.2" & sep & "5.3"

'Fill the first series with the data stored in the myString variable
chart.SetSeriesValuesFromString 0, myString

'Add the second series "Year 2007"
myString= "14" & sep & "9.9" & sep & "13.1" & sep & "11.5" & sep & "4.9"

'Fill the second series with the data stored in the myString variable
chart.SetSeriesValuesFromString 1, myString

'Specify the 2 series captions
myString= "Year 2006" & sep & "Year 2007"

'Set the series captions with the strings stored in the myString variable
chart.SetSeriesCaptionsFromString myString

Arguments

Remarks

VBScript Sample Code

See Also