Hi guys.
I haven't posted anything here for years so sorry if this has come up before.
I have a report in excel used in a call centre that tracks the number of calls an agent makes. Team Leaders want to see performance by month on a chart.
I have a chart that has an offset formula to change the range based on how many days there are in the month. eg if the month they want to see is Feb then it will only have 28 days of data on the chart. If it is Jul it will increase the days to 31 days. It also changes depending on how many people are in the team. If only 6 people on the team there are 6 columns of data. If there are 8 people the range will increase by 2 people.
The result of the Offset formula changes based on two ranges that update which are the days in the month and the number of agents.
The problem I am having is when I enter the Offset formula the chart updates perfectly. But then when ranges change that make up the offset formula the chart does not update.
If I go into the formula again the chart just has the static range, not the Offset formula. If I re-enter the formula after the ranges in the offset formula have changed the chart updates perfectly again. But I have to re-enter the formula.
It just seems to not keep the formula in the chart.
Does anyone have any ideas? This is what I am entering into the formula bar.
=Offset(ChartDataStart,0,0,DaysCount,AgentsCount)
I am stumped.
Thanks !!
I haven't posted anything here for years so sorry if this has come up before.
I have a report in excel used in a call centre that tracks the number of calls an agent makes. Team Leaders want to see performance by month on a chart.
I have a chart that has an offset formula to change the range based on how many days there are in the month. eg if the month they want to see is Feb then it will only have 28 days of data on the chart. If it is Jul it will increase the days to 31 days. It also changes depending on how many people are in the team. If only 6 people on the team there are 6 columns of data. If there are 8 people the range will increase by 2 people.
The result of the Offset formula changes based on two ranges that update which are the days in the month and the number of agents.
The problem I am having is when I enter the Offset formula the chart updates perfectly. But then when ranges change that make up the offset formula the chart does not update.
If I go into the formula again the chart just has the static range, not the Offset formula. If I re-enter the formula after the ranges in the offset formula have changed the chart updates perfectly again. But I have to re-enter the formula.
It just seems to not keep the formula in the chart.
Does anyone have any ideas? This is what I am entering into the formula bar.
=Offset(ChartDataStart,0,0,DaysCount,AgentsCount)
I am stumped.
Thanks !!