Charts - automatically updating data lables

[imported_unknown]

Is there any way to automatically update the data label on the last point only of a line chart when new data is added?

I'm sure there is an easy way to do this but I can't find it.

Cheers

 

[PaddyD]

Hi - welcome to the board!

Kind of depends how your data is set up, where you want the update to come from on the sheet etc...

take a look at the dynamic chart tutorial on Tushar's site:

http://www.tushar-mehta.com/

download the XYChart Labeler addin by Rod Bovey:

http://www.appspro.com/

which does all sorts of nice things...& post back with more details about your problem if you need...

Paddy

 

[imported_unknown]

Thanks, I'll check those sites out first.

Cheers

 

[imported_unknown]

Thanks, the dynamic chart tutorial gave me the answer - quite simple really.

Cheers