I am sort of new to excel. I use the spread sheet to track network up and
down time. I have two diffrent workbooks, one for lan and one for wan. I keep
years of data in the workbooks, but only want to see 6months on the charts.
How do I set up the chart so all i have to so is add the weeks line and the
chart is generated for 6 months and I dont have to do it manually?

thank you in advance for any help you can offer.