CategoryItems collection, Data object
For charts, this collection represents all Chart fact objects within the Body (Object).
For gauges, this collection represents all Bullet, Slider, Speedometer, Thermometer and TrafficLight actual fact objects. Additionally, it does not include the AddComputed method, or the Axis Type (Property). Data functions can be applied to fact values to aggregate values.
In this example, all items in the Chart Outliner are removed, and specific items added:
ActiveDocument.Sections["Chart"].Facts.RemoveAll() ActiveDocument.Sections["Chart"].Facts.Add("Amount_Sales") ActiveDocument.Sections["Chart"].Facts.Add("Unit_Sales")
Add(ItemName As String), AddComputedItem(Name As String, Expression As String, [optional] Index As Number ), Item (Value as NameOrIndex) Remove(Value as NameOrIndex), RemoveAll()
Read-only: Property Axis Type as BqChartAxisType, Property Count As Number