A
Andrew
I have a table that will be 52 rows down, each row representing a week. I
am tracking 3 sets of data on a weekly basis. One of the three columns is
the projected budget so it is complete through 52 weeks. Each week I enter
in the weekly sales and units. I graph these three series on the same
chart - the sales and budget figures are graphed on the Primary Y and the
units are graphed against the Secondary Y.
Rather than having the graph show all 52 weeks each week I would rather have
the chart add a week of data each week that actual sales and units are
entered.
Is there any way to enter a week number at the top of the table - say 26 and
the graph would be able to reference this 26 as to illustrate only the first
26 rows of data?
Any ideas would be great,
Thanx, Andrew
am tracking 3 sets of data on a weekly basis. One of the three columns is
the projected budget so it is complete through 52 weeks. Each week I enter
in the weekly sales and units. I graph these three series on the same
chart - the sales and budget figures are graphed on the Primary Y and the
units are graphed against the Secondary Y.
Rather than having the graph show all 52 weeks each week I would rather have
the chart add a week of data each week that actual sales and units are
entered.
Is there any way to enter a week number at the top of the table - say 26 and
the graph would be able to reference this 26 as to illustrate only the first
26 rows of data?
Any ideas would be great,
Thanx, Andrew