Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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").Pi votFields() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enable automatic refresh | Excel Worksheet Functions | |||
Store Excel Results in Access | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Value Errors with EXCEL XP not showing up in EXCEL 2000 | Links and Linking in Excel | |||
what is the page orientation in Excel and how do you change it? | New Users to Excel |