Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default A chart that always looks at the latest few weeks data in a table

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
  #2   Report Post  
Posted to microsoft.public.excel.charting
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
show weeks covered by the chart halbert12 Excel Discussion (Misc queries) 0 February 9th 09 08:10 PM
Latest value from table WRC Excel Worksheet Functions 3 December 11th 08 08:29 PM
Forecast based on latest 26 weeks data Graham Tritton Excel Worksheet Functions 0 June 11th 08 04:11 AM
Pivot Table Time in Weeks Rob[_2_] Excel Worksheet Functions 2 March 13th 07 04:58 PM
Need a base unit of weeks for chart Rich S. Charts and Charting in Excel 1 April 30th 06 05:08 AM


All times are GMT +1. The time now is 02:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"