Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show weeks covered by the chart | Excel Discussion (Misc queries) | |||
Latest value from table | Excel Worksheet Functions | |||
Forecast based on latest 26 weeks data | Excel Worksheet Functions | |||
Pivot Table Time in Weeks | Excel Worksheet Functions | |||
Need a base unit of weeks for chart | Charts and Charting in Excel |