Graph Source Data
 

Is there a way to make a graph source data pull only the last 14 days of info ??
I have a data source that gives me 90 days of info, but on one graph, I want to limit it to
the last 14 days and not have to manually adjust it every day.


Brian

Graph Source Data
 

I think your best bet is to build a go-bewtween data set that links to
your chart.

on that one you can use the = now() formula and add or subtract days
from it to lookup in your other table of data. That way you don't have
to jack around with a lot of complicated data set manipulations in VBA
to tweak your chart each day.

Regards,
Jamie
Brian wrote:
Is there a way to make a graph source data pull only the last 14 days of info ??
I have a data source that gives me 90 days of info, but on one graph, I want to limit it to
the last 14 days and not have to manually adjust it every day.


Brian