Hi there,
I've been asked by my boss to create a 7-day rolling chart following three sets of data. I need the totals on the y-axis and the dates on the x-axis. I feel I've done well, I followed an online tutorial and learned about=OFFSET but while the tutorial worked perfectly for a single dataset with dates, when I added more datasets, the dates threw a hissy fit. What I would like, is for the dates rolling with the cells that contain information so I can
preemptively drag down the dates for the season because that is what the workers are used too.
Though I have the datasets working nicely, the fact that the dates aren't working, while a minor irritation, is a nagging failure to me. I know dates in excel can be trying but is there anything I can do to fix this please?
Thanking you in advance,
Aaron
I've been asked by my boss to create a 7-day rolling chart following three sets of data. I need the totals on the y-axis and the dates on the x-axis. I feel I've done well, I followed an online tutorial and learned about=OFFSET but while the tutorial worked perfectly for a single dataset with dates, when I added more datasets, the dates threw a hissy fit. What I would like, is for the dates rolling with the cells that contain information so I can
preemptively drag down the dates for the season because that is what the workers are used too.
Though I have the datasets working nicely, the fact that the dates aren't working, while a minor irritation, is a nagging failure to me. I know dates in excel can be trying but is there anything I can do to fix this please?
Thanking you in advance,
Aaron