Series and Categories OWC XP v10

[Michael Weiss]

I have a pivot chart control connected to a pivot control
which pulls data from an OLAP cube. In the following code
I am trying to set my chart up to pull the categories
from the OrigDate dimension (currently on the column axis
on the pivot control) and the series from the "Call
Jurisdiction" dimension (currently on the rows axis on
the pivot control). Can anyone tell me where I am going
wrong here? No matter what settings I use, the date
values do not show up as the chart categories...
Thanks,
Michael

' Bind the Chart control to the PivotTable control
cspace.DataSource = ptable

with cspace
..HasMultipleCharts = true
..ChartLayout = c.chChartLayoutHorizontal
..displayfieldbuttons = false
..AllowPropertyToolbox = False
..interior.color = "white"
..HasChartSpaceLegend = True
..ChartSpaceLegend.Position = c.chLegendPositionLeft
..ChartSpaceLegend.Font.Name = "Arial"
..ChartSpaceLegend.Font.Size = 7
..ChartWrapCount = 2
end with


Set cht = cspace.charts(0)
With cht
..Type = c.chChartTypeLine
..SetData c.chDimSeriesNames, c.chDataBound,
c.chPivotColumns
..SetData c.chDimCategories, c.chDataBound, c.chPivotRows
..SetData c.chDimValues, c.chDataBound, "Call Dur"
End With

 

[Michael Weiss]

Please disregard this posting and see my new posting of same subject.
Thank you,
Michael