View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Dynamic chart ranges

Excel 2007 PivotTable, PivotChart
Consolidate X Y data from multiple sheets.
Select sheets, Y sets from drop-down list.
Tables and chart all dynamic.
http://c0444202.cdn.cloudfiles.racks.../02_02_10.xlsx