How do I change the pivot chart source data?

[Frank Bacchus]

I have a pivot chart which pick up its data from rows C2-E22. Now I want to expand from rows C2-E32. I can seem to find the source data button on the ribbon (I am using Excel 2010). How can this be done?

 

[Hui]

Click anywhere in the PT
Goto the PivotTable Tools, Options Tab
Change Source Data

 

[Frank Bacchus]

Click anywhere in the PT
Goto the PivotTable Tools, Options Tab
Change Source Data

View attachment 29796

Thanks Hui

 

[candybg]

I know you didn't ask, BUT : )
You might want to consider making your data a TABLE - and reference the table as your Pivot Table data source. Then as your data lines increase, the table will automatically increase and your Pivot Table will incorporate the range change automatically - just refresh the Pivot Table.

Hope this helps!

 

[Frank Bacchus]

I know you didn't ask, BUT : )
You might want to consider making your data a TABLE - and reference the table as your Pivot Table data source. Then as your data lines increase, the table will automatically increase and your Pivot Table will incorporate the range change automatically - just refresh the Pivot Table.

Hope this helps!

Thanks