Hello to all,
I have a conundrum. I have a work book with multiple sheets. I am trying to make a chart that is a continuous rolling chart of the last 365 days of sales. The sheet that has the data is called DAILY VALUES, the sheet where I would like the chart is called 100LL Monthly Sales Comparison.
I have the following names defined:
ChtData100LL =offset('DAILY VALUES'!$H$1, COUNT('DAILY VALUES'!$H$H, 0,-3661) to select the quantity sold on any given day.
ChtLabels100LL =offset(ChtData100LL,0,-7) to define my date column.
The DAILY VALUES sheet has an entry for every day since 2009. When I selected my data for the chart I had a plot for the year of 5/11/14 (Auto) to 5/13/15 (Auto).
How can I change the formula/data name to get a range that is one year back from the current date?
Thank you for your kind help.
I have a conundrum. I have a work book with multiple sheets. I am trying to make a chart that is a continuous rolling chart of the last 365 days of sales. The sheet that has the data is called DAILY VALUES, the sheet where I would like the chart is called 100LL Monthly Sales Comparison.
I have the following names defined:
ChtData100LL =offset('DAILY VALUES'!$H$1, COUNT('DAILY VALUES'!$H$H, 0,-3661) to select the quantity sold on any given day.
ChtLabels100LL =offset(ChtData100LL,0,-7) to define my date column.
The DAILY VALUES sheet has an entry for every day since 2009. When I selected my data for the chart I had a plot for the year of 5/11/14 (Auto) to 5/13/15 (Auto).
How can I change the formula/data name to get a range that is one year back from the current date?
Thank you for your kind help.