Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 29th 04, 01:31 PM
Bigxcr
 
Posts: n/a
Default How can I auto update a graph?

I was wondering if there is a way for me to auto update a chart that I am
using.

  #2   Report Post  
Old November 29th 04, 02:05 PM
Don Guillett
 
Posts: n/a
Default

Lot's of ways. The usual is to use a defined name for the series with an
offset formula to include row/columns

use a defined name such as =offset($a$1,0,0,counta($a:$a),4).
Go to these for more info

http://www.tushar-mehta.com/
http://peltiertech.com/

--
Don Guillett
SalesAid Software

"Bigxcr" wrote in message
...
I was wondering if there is a way for me to auto update a chart that I am
using.



  #3   Report Post  
Old November 30th 04, 07:40 PM
Bernard Liengme
 
Posts: n/a
Default

I'd like to add to Don's fine answer: if you are using Excel 2003 and make
the data a List (Data | List - Create List) then when more data is added to
the list, the chart automatically expands to include the new values.

best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Bigxcr" wrote in message
...
I was wondering if there is a way for me to auto update a chart that I am
using.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 05:40 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017