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.

Jon Peltier has information on creating dynamic charts:

http://www.peltiertech.com/Excel/Charts/Dynamics.html


Tom wrote:
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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi Tom..........

You can use the Data Filter Autofilter to select the specific date-range
you wish to chart, then copy and paste those results to a second sheet, and
use that data location to set up your chart...........then when you change
the Autofilter results, and copy them to Sheet 2, your chart will change
accordingly........not exactly what you asked for, but close, and of course
it can all be set up on macros to work with pushbuttons if you have to do it
frequently...............

Vaya con Dios,
Chuck, CABGx3




"Tom" <Tom @discussions.microsoft.com wrote in message
...
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.