Pivot chart uneditable

[Hari]

Hi,

I have inherited a workbook from my boss. It contains some Pivot tables
and Pivot charts.

Strangely one of the pivot charts has no field buttons in it. Am not
able to understand as to why it is so. The Pivot table on which the
chart is based does have One column field and 2 row fields (no page
fields).

Please guide me on the same.

regards,
HP
India

[Hari]

Hi,

If I need to provide more information on this problem, please let me
know.

Regards,
HP
India

[Jon Peltier]

Did someone copy the pivot table, and paste-special as values?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Hari" <excel_hari@yahoo.com> wrote in message
news:1148146634.078185.18210@i39g2000cwa.googlegroups.com...
> Hi,
>
> I have inherited a workbook from my boss. It contains some Pivot tables
> and Pivot charts.
>
> Strangely one of the pivot charts has no field buttons in it. Am not
> able to understand as to why it is so. The Pivot table on which the
> chart is based does have One column field and 2 row fields (no page
> fields).
>
> Please guide me on the same.
>
> regards,
> HP
> India
>

[Hari]

Jon,

Thanks for jumping in.

The pivot table is editable. When right click on any cell within Pivot
table, I can see the options -- Format cells, Pivot Chart, Pivot Table
wizard etc.

Presently, I have drawn the chart by pulling summarized data from a
table created using SumProduct formulas (and hence avoiding the usage
of Pivot tables). But even then I want to know as to why Pivot chart
linked to Pivot table is not working, so that I can troublesoot in
future. (Actually, am more comfortable doing summarization with
sumproduct rather than Pivot and would like to know get my hands dirty
with the intricacies of Pivot as well.)

regards,
HP
India