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-19-2008, 01:55 AM
martinpe martinpe is offline
Registered User
 
Join Date: 08 Aug 2008
Location: Australia
Posts: 24
martinpe is on a distinguished road
How can Self updating graphs in excel be created

I have been working on the same database for a while now, hence there is alot of data... and I want to be able to build graphs that are self updating whenever I enter new data, this is how I have built the majority of the database and would like to keep it that way.. How can you do that... is it even at all possible?

thanks
__________________
Peter Martin
Reply With Quote
  #2  
Old 08-19-2008, 04:25 AM
sweep's Avatar
sweep sweep is offline
Valued Forum Contributor
 
Join Date: 03 Apr 2007
Location: England - Starting the invasion
Posts: 853
sweep is on a distinguished road
Hi,

You can make a graph "auto updating" by using a dynamic rangle for your data.

http://www.meadinkent.co.uk/xlgraphoffset.htm
__________________
I hope that helps!

Dave

have you tried google?
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hisorical Excel Files - Database daverskully Excel General 0 04-04-2008 03:30 PM
Excel 2003 Not Excelling in Handling 2000 .xls File pands Excel Miscellaneous 4 02-27-2007 05:56 PM
Excel updating source data issue... Dagwood2005 Excel Miscellaneous 1 02-01-2007 05:32 PM
Excel Template Problem - updating records elisebev Excel General 3 01-26-2007 08:04 AM
Problem Automatically Importing Excel Graphs into Powerpoint. sawyer Excel Miscellaneous 2 09-12-2006 11:33 AM


All times are GMT -4. The time now is 06:07 PM.


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