Dynamic Charts
 

Hey,

I have set up a bunch of macros to create a spread sheet that has
about 35 different items. Right now I have it set up so you can
select up to five different items with a scroll down list to enter
into a graph I have aleady made.

There are two problems with this system
1. I have to change the range every time I enter new data (which is
every day) I know there is a way to stop this but I can't figure it
out.

2. The most important thing is I want to be able to select a certain
range of dates as the spread sheet contains four months of data and I
plan on using this same spread sheet if possible for ever. This mean
it oculd have 10 years of data in it. It also may have more then one
update per day so I could have 1 lrow for one day or 7 row for one day
depending on the days production
So is it possible to have a scroll list of dates (start and end) to
select or a slider bar......anything really just so I can have some
flexability.

Dynamic Charts
 

A while ago i did some like what u are looking for
Take a look and feel free to use if u can
but u are on ur one from there

http://pmexcelent.dk/SpinGraf.xls


" skrev:

Hey,

I have set up a bunch of macros to create a spread sheet that has
about 35 different items. Right now I have it set up so you can
select up to five different items with a scroll down list to enter
into a graph I have aleady made.

There are two problems with this system
1. I have to change the range every time I enter new data (which is
every day) I know there is a way to stop this but I can't figure it
out.

2. The most important thing is I want to be able to select a certain
range of dates as the spread sheet contains four months of data and I
plan on using this same spread sheet if possible for ever. This mean
it oculd have 10 years of data in it. It also may have more then one
update per day so I could have 1 lrow for one day or 7 row for one day
depending on the days production
So is it possible to have a scroll list of dates (start and end) to
select or a slider bar......anything really just so I can have some
flexability.