View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta[_4_] Tushar Mehta[_4_] is offline
external usenet poster
 
Posts: 66
Default A chart that always looks at the latest few weeks data in a table

See
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html
particularly example 2
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"broken hippy" wrote:

Hi,

Any idea how I would create a chart that always looks at the last 12 weeks
data in a table that gets added to each week

Many Thanks

DC