View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Excel 2007-Pivot Chart Expensding data source

Hi Lee

From Menu-'PivotTable Tools' select 'Change Data Source'. Choose the Feb
data holding the Control key. This will select multiple ranges.

Jacob
(If this post helps please hit Yes)