Automatically format charts with range of dates

Hi,

I have sent you your revised example file, explaining how to use filtering,
3 times now.
Does this not do what you want?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Sean Moor" wrote in message
...
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

Thanks for the reply. I have sent you another emailing explaining everything
I am trying to do. I may have not explained throughouly want I wanted. I
was able to do it using Dynamic Name Ranges as per another MVP on here Jon
showed me. But it is only allowing me to chart one month as my months are
separated by tabs but all on one spreadsheet so by doing it by Dynamic Name
Range it won't work.

Filtering is a great idea yes btu according to the big bosses here they
would rather have a spot where you can enter in a set of dates or have say a
dropdown menu with dates you select (start/end range) instead of a greater
than or equal to etc filter process. But filter process I might have to go
with until I figure something more out but with filtering if I set autofilter
on all my months how could I have it carry over like on my say April tab I do
greater than or equal to 28 but then want it to graph until May 4. Bcause
they are on different tabs that won't work then right?

Thanks Andy

"Andy Pope" wrote:

Hi,

I have sent you your revised example file, explaining how to use filtering,
3 times now.
Does this not do what you want?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Sean Moor" wrote in message
...
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

Check you spam folder as I sent you a file on the 12th. Sent it again today.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Sean Moor" wrote in message
...
Thanks for the reply. I have sent you another emailing explaining
everything
I am trying to do. I may have not explained throughouly want I wanted. I
was able to do it using Dynamic Name Ranges as per another MVP on here Jon
showed me. But it is only allowing me to chart one month as my months are
separated by tabs but all on one spreadsheet so by doing it by Dynamic
Name
Range it won't work.

Filtering is a great idea yes btu according to the big bosses here they
would rather have a spot where you can enter in a set of dates or have say
a
dropdown menu with dates you select (start/end range) instead of a greater
than or equal to etc filter process. But filter process I might have to
go
with until I figure something more out but with filtering if I set
autofilter
on all my months how could I have it carry over like on my say April tab I
do
greater than or equal to 28 but then want it to graph until May 4. Bcause
they are on different tabs that won't work then right?

Thanks Andy

"Andy Pope" wrote:

Hi,

I have sent you your revised example file, explaining how to use
filtering,
3 times now.
Does this not do what you want?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Sean Moor" wrote in message
...
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

I will when I get back to work Andy today.. just incase though can you send
it to my hotmail address too..

thanks again for all your amazing effort

"Andy Pope" wrote:

Check you spam folder as I sent you a file on the 12th. Sent it again today.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Sean Moor" wrote in message
...
Thanks for the reply. I have sent you another emailing explaining
everything
I am trying to do. I may have not explained throughouly want I wanted. I
was able to do it using Dynamic Name Ranges as per another MVP on here Jon
showed me. But it is only allowing me to chart one month as my months are
separated by tabs but all on one spreadsheet so by doing it by Dynamic
Name
Range it won't work.

Filtering is a great idea yes btu according to the big bosses here they
would rather have a spot where you can enter in a set of dates or have say
a
dropdown menu with dates you select (start/end range) instead of a greater
than or equal to etc filter process. But filter process I might have to
go
with until I figure something more out but with filtering if I set
autofilter
on all my months how could I have it carry over like on my say April tab I
do
greater than or equal to 28 but then want it to graph until May 4. Bcause
they are on different tabs that won't work then right?

Thanks Andy

"Andy Pope" wrote:

Hi,

I have sent you your revised example file, explaining how to use
filtering,
3 times now.
Does this not do what you want?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Sean Moor" wrote in message
...
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