PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Where does Excel store the orientation of PivotFields?

Reply

Where does Excel store the orientation of PivotFields?

 
Thread Tools Rate Thread
Old 03-04-2006, 04:02 PM   #1
=?Utf-8?B?VmFsZW50aW4=?=
Guest
 
Posts: n/a
Default Where does Excel store the orientation of PivotFields?


Hi there,
I'm trying to find out where Excel stores the orientation of a PivotField,
especially once it has been draged into position.

Right now I'm using the
AcitveChart.PivotLayout.PivotTable("TableName").PivotFields() Function to get
a collection of all Fields within that Table. But even though all Fields are
in the collection each of them has the orientation "xlHidden" regardless
where I dragged them at the chart. The display of the fields within the
charts works perfectly fine.

Can Somebody Help me please?
  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off