Series and Categories OWC 10

[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. If I use:
Dim categories(2)
categories(0) = "OrigDate"
categories(1) = "CallJurisdiction"
cspace.SetData c.chDimCategories, c.chDataBound, categories

The chart control moves my column axis members (OrigDate) to the row axis of
the pivot control and then nests the OrigDate fieldset within the
CallJurisdiction fieldset which is not bad per se but it gives me a view of
the data on the pivot control that is not acceptable by target audience.
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,
"CallJurisdiction"
...SetData c.chDimCategories, c.chDataBound, "OrigDate"
...SetData c.chDimValues, c.chDataBound, "Call Dur"
End With