Hi there,
I am currently putting together information on call centre statistics. I have time from 00:00-00:30, 00:30-01:00 and so on up to 24:00, with data associated with each time period, i.e. calls offered, calls abandoned etc. I have created a chart for the data, however am doing this for an entire month, so there will be a different table with a different chart for every day. However what I want to do is be able to copy and past the chart on the worksheet and get it to automatically link to the next day's data, like a formula does if you don't use absolute cell references.
Is this possible? If it is, I would really appreciate your help, as it will save me a lot of time having to manually update the series data on each chart.
_________________
Cheers,
Brandon
This message was edited by bomalley on 2002-09-18 22:11
I am currently putting together information on call centre statistics. I have time from 00:00-00:30, 00:30-01:00 and so on up to 24:00, with data associated with each time period, i.e. calls offered, calls abandoned etc. I have created a chart for the data, however am doing this for an entire month, so there will be a different table with a different chart for every day. However what I want to do is be able to copy and past the chart on the worksheet and get it to automatically link to the next day's data, like a formula does if you don't use absolute cell references.
Is this possible? If it is, I would really appreciate your help, as it will save me a lot of time having to manually update the series data on each chart.
_________________
Cheers,
Brandon
This message was edited by bomalley on 2002-09-18 22:11
