How do I set up a chart that auto updates as new info is added?
 

I need to set up a chart that automatically updates as new information is
added to an existing chart range in Microsoft Excel. Please help!

How do I set up a chart that auto updates as new info is added?
 

See Tushar Mehta's site for a short course on Dynamic Charting and some
sample files.

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

Alternative site is Stephen Bullen's.

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

Download either or both FunChrt1 and FunChrt7


Gord Dibben MS Excel MVP

On Thu, 5 Feb 2009 15:00:12 -0800, Alison
wrote:

I need to set up a chart that automatically updates as new information is
added to an existing chart range in Microsoft Excel. Please help!

How do I set up a chart that auto updates as new info is added?
 

If you have Excel 2003, convert the range to a list (data menu list
create list). Any formula (including a chart formula) that references an
entire column of the list updates as the list grows. In Excel 2007, this is
called a table instead of a list, but the functionality is the same.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
See Tushar Mehta's site for a short course on Dynamic Charting and some
sample files.

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

Alternative site is Stephen Bullen's.

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

Download either or both FunChrt1 and FunChrt7


Gord Dibben MS Excel MVP

On Thu, 5 Feb 2009 15:00:12 -0800, Alison

wrote:

I need to set up a chart that automatically updates as new information is
added to an existing chart range in Microsoft Excel. Please help!