This refers to my earlier post on the "AutoCalc option grayed out ...".

I am experimenting with different scenarios. I want to point out that I am having this problem working with a query with calculated fields from a table, which forms the input data.

When I work with the table itself (containing the input data), in the Pivot Chart view, I am able to view all the options in the AutoCalc menu. I can choose Average or Sum or Max etc.

This is strange. The option for a query based on this table is only Count.

Has anyone noticed a similar problem?

Once a Pivot chart is created, the Legend options seem to be limited. For example, I cannot change the orientation of the Axis titles, insert values for the bars at their tips etc.

- Krishna