I Am hoping that some one can help me with this problem. I am trying to
create a chart in XL 2003 that will automatically update as data is added.
the data ranges are variable and may have 10 to 250 entries. For example I
may require a data range of A2:A30 and G2:G30 or A2:A220 and G2:G220. I
require this chart to update with expanding data tables. Can anyone point me
in the right direction.

Thanks in advance NAC

See Stephen Bullen's site for a download.

http://www.oaltd.co.uk/Excel/Default.htm

FunChrt1 is a workbook showing how to create dynamic ranges for charting.

Or browse Tushar Mehta's site for dynamic charts.

http://www.tushar-mehta.com/excel/ne...rts/index.html


Gord Dibben MS Excel MVP

On Mon, 6 Aug 2007 14:44:02 -0700, CattleDr <(E-Mail Removed)>
wrote:

>I Am hoping that some one can help me with this problem. I am trying to
>create a chart in XL 2003 that will automatically update as data is added.
>the data ranges are variable and may have 10 to 250 entries. For example I
>may require a data range of A2:A30 and G2:G30 or A2:A220 and G2:G220. I
>require this chart to update with expanding data tables. Can anyone point me
>in the right direction.
>
>Thanks in advance NAC