Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I was wondering if there is a way for me to auto update a chart that I am
using. |
#2
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |