| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum a column correctly after more info is added by sorting | Excel Worksheet Functions | |||
| question on links where info is added and cell location is wrong | Links and Linking in Excel | |||
| Link to other Worksheets - when data is added updates master works | Excel Worksheet Functions | |||
| How do i set Excel to record the date etc of info added | Excel Worksheet Functions | |||
| My Excel Chart No Longer Auto Updates | Excel Discussion (Misc queries) | |||
Linear Mode
