Linking data in charts

bomalley

New Member
Joined
Feb 16, 2002
Messages
21
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
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
you need to get your chart to refer to dynamic named ranges, where the ranges are set in reference to the corresponding date criteria...

see the chart tutorials on Tushar's site for ideas:

http://www.tushar-mehta.com


Post back if this isn't what you need!

Paddy
 

Forum statistics

Threads
1,144,112
Messages
5,722,544
Members
422,446
Latest member
jsasiadek35

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top