Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Automatically Update Chart

I am trying to create a chart that will automatically update as new data is added.

My spreadsheet is laid out like below

Column A // Column B // Column C // Column D // Column E
Row 43 Cost Data // 2/14/2010 // 2/28/2010 // 3/14/2010 // 3/18/2010
Row 44 GS // 1.00 // 1.25
Row 45 SW // 1.15 // 1.20
Row 46 SE // 1.10 // 1.21

// indicates seperate columns

I am trying to create a dynamic name range that I can use for the chart that will update the X and Y Values as new rows are filled in.

Here is what I have done so far.

XValues =OFFSET('CostData.xls'!YValues,-1,-1)
YValues =OFFSET('CostData'!$A$43,0,0,COUNTA('CostData'!$A: $A),COUNTA('CostData'!$1:$1))

I can not seem to get the name ranges setup correctly.

Last edited by sirexcel7 : October 28th 10 at 04:00 AM
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
Chart update automatically DaveR Charts and Charting in Excel 1 February 1st 08 03:48 PM
Automatically Update Chart(s) with new data. Merlyn Charts and Charting in Excel 4 July 16th 07 07:18 PM
how do I automatically update a text box in a chart? Kath Charts and Charting in Excel 1 February 28th 07 10:55 AM
how do i get the data in a chart to automatically update? kinjamyhaz Charts and Charting in Excel 0 August 14th 06 03:42 PM
how do i update a chart area automatically Kay Charts and Charting in Excel 4 February 10th 06 09:10 PM


All times are GMT +1. The time now is 10:37 AM.

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

About Us

"It's about Microsoft Excel"