Returns the set of values from a range of given time members. Often used to provide an OLAP data source for In-Cell Chart formulas.

XL3DataSeries( Connection, TimeHierarchy, PeriodMember, PeriodCount, Measure, Hierarchy1, Member1,…, Hierarchy100, Member100 )

ParameterDescription
ConnectionConnection number to use.
TimeHierarchyName of the time hierarchy to use.
PeriodMemberThe time member to use.
PeriodCountThe number of periods to return.
MeasureThe measure to use.
Hierarchy1,…, HierarchyNName of the hierarchy that the member applies to for example, "Measures" or "[Customer].[Customer Geography]".
Member1,…, MemberNEither a single-member's unique name or an XL3Member formula.

These examples are based on the Bicycle Sales cube.

This example returns the set of 12 Revenues for January 2004 to December 2004.

=XL3DataSeries( 1, "Time", "December 2004", 12, "Value", "KeyFigures", "Revenue" )

This example returns a column chart for a set of 12 Revenues from January 2004 to December 2004.

=XL3SparkColumnsM( XL3DataSeries( 1, "Time", "December 2004", 12, "Value", "KeyFigures", "Revenue" ) )