Source data, in Chart Menu, is grey and not accessible.

I set up a pivot table and designed a chart, saved and closed out of the
workbook. Upon returning to work on this project, when selecting the chart
menu to work with my source data, the source data is grey and not accessible.
What might be causing this and can I correct it?

It's a pivot chart. As soon as it's created, it's linked permanently to the
pivot table, and you cannot change the source data. you cannot add more data
that's not in the pivot table to the chart, nor can you remove data that is
in the pivot table from the chart.

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


"JMO" <JMO@discussions.microsoft.com> wrote in message
news:683A7604-9240-4340-A7FE-87EEEDCCEC26@microsoft.com...
>I set up a pivot table and designed a chart, saved and closed out of the
> workbook. Upon returning to work on this project, when selecting the chart
> menu to work with my source data, the source data is grey and not
> accessible.
> What might be causing this and can I correct it?

Thanks for your reply. I was not attempting to change the data - only to
rearrage the display of the data on the chart.

From another source, I have learned that if I click inside the data to set
up a chart, then I cannot go back and edit the Source Data, however, when I
do a custom chart by clicking outside of the pivot table, then I can elect to
change the way the cdata is displayed, by rearranging the the data series of
the data within the pivot table. This is what I was attempting to do.

Thanks again.

"Jon Peltier" wrote:

> It's a pivot chart. As soon as it's created, it's linked permanently to the
> pivot table, and you cannot change the source data. you cannot add more data
> that's not in the pivot table to the chart, nor can you remove data that is
> in the pivot table from the chart.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
> "JMO" <JMO@discussions.microsoft.com> wrote in message
> news:683A7604-9240-4340-A7FE-87EEEDCCEC26@microsoft.com...
> >I set up a pivot table and designed a chart, saved and closed out of the
> > workbook. Upon returning to work on this project, when selecting the chart
> > menu to work with my source data, the source data is grey and not
> > accessible.
> > What might be causing this and can I correct it?
>
>
>