Hi,

Select the pivot table and choose Data, Pivot Table and Pivot Chart Report,
click Back once. Your there.

I will send a more lengthy, but better solution in the next email.
--
Thanks,
Shane Devenshire


"JN" wrote:

I have a pivot chart based on A1 thru D10 in and Excel 2003 workbook. I
would like to expand it to A1 thru F20, but I don't see how that gets done.
How do you respecify the data range for the pivot table?