IgnBan
02-23-2008, 09:13 PM
How can I display only the last data point value in a 4 series Chart as data is input at the end of the day in the data table? I want the Chart to show only the last data points. I have four series coming from a named ranges;
I’m using Xld provided formula for the ranges
Date =OFFSET(Sheet1!$A$5,,,COUNTA(Sheet1!$A:$A)-COUNTA(Sheet1!$A$1:$A$4),1)
Object1=OFFSET(Sheet1!$B$5,,,COUNTA(Sheet1!$B:$B)-COUNTA(Sheet1!$B$1:$B$4),1)
Object2=OFFSET(Sheet1!$C$5,,,COUNTA(Sheet1!$C:$C)-COUNTA(Sheet1!$C$1:$C$4),1)
Object3=OFFSET(Sheet1!$D$5,,,COUNTA(Sheet1!$D:$D)-COUNTA(Sheet1!$D$1:$D$4),1)
I know I can use the “=” in the formula bar to insert a text box and link the data point, but how can I make it “follow” the last data point in the data Table?
Have search in the Forum and Goggled it, can find an answer.
Attached sample workbook.
Any help in greatly appreciated in advance!:thumb
I’m using Xld provided formula for the ranges
Date =OFFSET(Sheet1!$A$5,,,COUNTA(Sheet1!$A:$A)-COUNTA(Sheet1!$A$1:$A$4),1)
Object1=OFFSET(Sheet1!$B$5,,,COUNTA(Sheet1!$B:$B)-COUNTA(Sheet1!$B$1:$B$4),1)
Object2=OFFSET(Sheet1!$C$5,,,COUNTA(Sheet1!$C:$C)-COUNTA(Sheet1!$C$1:$C$4),1)
Object3=OFFSET(Sheet1!$D$5,,,COUNTA(Sheet1!$D:$D)-COUNTA(Sheet1!$D$1:$D$4),1)
I know I can use the “=” in the formula bar to insert a text box and link the data point, but how can I make it “follow” the last data point in the data Table?
Have search in the Forum and Goggled it, can find an answer.
Attached sample workbook.
Any help in greatly appreciated in advance!:thumb