PivotTable autofit/coloring result grid/doco - please help!

J

Jonathan

Hi All,

Having huge difficulty with getting OWC10 PivotTable to look how I want it
to. Questions:

1) When I autofit the total headings they don't fill the entire column -
there is a gap that looks quite confusing when there are many columns. I
would like the total headings to completely fill the column widths but can't
see how to do this.

PivotTable1.ActiveView.AddTotal("VALUE TOTAL",
PivotTable1.ActiveView.FieldSets("VALUE").Fields("VALUE"),
plFunctionSum).AutoFit=True

2) Is there any way to colour the resulting grid of column totals
individually rather than have a single mass of 1 color. I'd like to alternate
the column colors for readability but once again I am confused!

The main problem is lack of detailed documentation and having to guess what
objects do what. I have hunted down every article I can find but there is no
good overview of the whole object hierarchy. Worse case I will export data
from the PivotTable and reformat in the Spreadsheet component but the
end-user will lose some functionality.

Any help much appreciated!

Thanks, Jonathan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top