View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
JohnB JohnB is offline
external usenet poster
 
Posts: 53
Default Change source data in a pivot chart

Hi All

I have a stack of pivot tables each with a pivot chart. I now need to move
the location ot the Pivot tables which is the source data to the charts. But
in Chart=Source data.. is dimmed out and i can't find a way of changing the
pivot chart's pivot table location.

Any suggestions??

TIA
jpohnb