I have several questions, but first of all the pivotTable.RowRange does not give me the row field range as “A2:A7” it gives me 4 attributes (startColumn, startRow, endColumn, endRow) as integers which are not useable as dataranges (missing the column part).
The DataBodyRange is constructed the same way.
The pivotTable object has a collection of dataFields, which are those i have added to the pivotTable and named. Each of these has an attribute called “Range” which is null.
Why is this attribute null? should i not contain the datarange of the specific dataField?
It would make a lot of sense to be able to get the different ranges from the pivotTable directly from the datafields added.
When you bind a chart to at pivotTable source, why are the ranges in the pivot not added to the Nseries property of the chart object? Is there anyway to accomplish this, because this would mean that you don’t have to bind each series yourself. The chart works fine with just the PivotDataSource, but the Nseries property is null
Hope you can help us on this