ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Usenet Groups > Excel Charting

Notices

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 08-17-2008, 06:42 AM
emailkia emailkia is offline
Registered User
 
Join Date: 17 Aug 2008
Location: Sweden
Posts: 1
emailkia is on a distinguished road
adding data to diagram continuously

Heeeeelp
I have a diagram and the data being continuously added to the table. I would like to diagram to also add these entries automatically to the diagram. How do I do that??? Can Excel do that at all??? Many thanx for you guys!!!
Reply With Quote
  #2  
Old 08-17-2008, 08:25 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Moderator
 
Join Date: 10 May 2004
Location: Essex, UK
Posts: 2,305
Andy Pope will become famous soon enough Andy Pope will become famous soon enough
If you make your data a list (table in 2007) and base the chart on that it will automatically extend.

Otherwise you can create dynamic named ranges and use those as the series data source. There are many examples of dynamic named ranges on the site, so use the search. If you still have questions post back.
__________________
Cheers
Andy
Reply With Quote
Reply

Bookmarks

New topics in Excel Charting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump


All times are GMT -4. The time now is 05:04 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0