PDA

View Full Version : Solved: Display only last data point in a Chart



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

Bob Phillips
02-24-2008, 02:39 AM
If I understand correctly, use formulae of

Date =OFFSET(Sheet1!$A$4,COUNTA(Sheet1!$A:$A)-COUNTA(Sheet1!$A$1:$A$4),0)
Object1=OFFSET(Sheet1!$B$4,COUNTA(Sheet1!$B:$B)-COUNTA(Sheet1!$B$1:$B$4),0)
Object2=OFFSET(Sheet1!$C$4,COUNTA(Sheet1!$C:$C)-COUNTA(Sheet1!$C$1:$C$4),0)
Object3=OFFSET(Sheet1!$D$4,COUNTA(Sheet1!$D:$D)-COUNTA(Sheet1!$D$1:$D$4),0)

IgnBan
02-24-2008, 10:11 AM
Works great!, thanks Xld :thumb