Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart update automatically | Charts and Charting in Excel | |||
Automatically Update Chart(s) with new data. | Charts and Charting in Excel | |||
how do I automatically update a text box in a chart? | Charts and Charting in Excel | |||
how do i get the data in a chart to automatically update? | Charts and Charting in Excel | |||
how do i update a chart area automatically | Charts and Charting in Excel |