Edit the data in a chart

[Soms]

Hi Members,

I have created a pie chart from a pivit table range of data. But, I am not able to edit the data in the chart options..its greyed out. Any suggestions? Attached my screenshot.

 

[Nebu]

Hi:

You cannot edit the data sources for a chart based on a pivot , here is a workaround for the same
http://www.contextures.com/excelpivotchartsourcedata.html

Thanks