Hi all,

I would like to create a chart where date is the X axsis and $ value is the Y axsis.

The $ value cell (i3) is comprised of many variables and changing on a daily basis.

Is there a way for excel to automatically plot $ value points on a chart on a weekly basis (i.e. every Tuesday) for a rolling 12 month period?

Thanks in advance!!!!