Hi Andy,

Just wondering fi you happen to get my email and was able to possibly give
me a little more information on what I am trying to do. I have pretty much
tried everything on links you have gave me but I must be missing something.

"Sean Moor" wrote:


And BTW would it be easier to be creating a macro for this setup or no?.. If
so whats the best place I can go to to find out an easy macro setup?
"Sean Moor" wrote:

What I am trying to do is I have 4 charts that are linked with data from
another spreadsheet. They are basically week totals for my business and make
a chart compared to say last year.

What I want to do though is have an option on my report that I can enter in
a specific date or a range of dates and have the charts automatically filter
the new data in and change. Instead of having to go into the chart data and
changing what series of data I want to have a chart for I want to be able to
just enter eg. "April 12-April 18" and have the charts bring up that data to
reflect the new option.

Any suggestinos would be appreciated. I heard macros is a good idea but I
have no idea how to use them