Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Limited data range
I update a data table weekly, but I would like a chart that only displays the
last 13 weeks of information. Is there any way to automate this, or would I have to update the range manually every week? Thanks!! |
#2
|
|||
|
|||
This should help you:
http://www.peltiertech.com/Excel/Charts/Dynamics.html "SEIMurf" wrote: I update a data table weekly, but I would like a chart that only displays the last 13 weeks of information. Is there any way to automate this, or would I have to update the range manually every week? Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation (in a range of cells) | Excel Worksheet Functions | |||
data range | Excel Discussion (Misc queries) | |||
Formula Changes when data entered in referenced range | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |