how to add data label automatically

[koi]

hi all,

i have a question regarding data label, lets just say we have something to be input as line chart in every week and we want to show the latest week value in the line chart,

normally what i do is i select the latest dot in line chart and click add data label, then delete the previous week value.

is there any idea how to make this automatic?

thanks

 

[koi]

hi all,

i think i found a trick by insert text box then point the text box to a cell, in the cell just put a formula to retrieve latest number.

 

[SirJB7]

Hi, koi!
Nice and effective trick. Thank you for sharing it with the community.
Regards!

 

[chronot]

Hello!

I'd like that the data label should be updated automatically when I add new data. For example, I entered data for January 9 (highlighted) and I updated the chart, so I'd like the labels are updated too. How can I do that? Here is the example. Thanks a lot for your help!

 

[oldchippy]

Hi chronot,

Welcome to the forum, you should really start a new thread, please read the rules

http://chandoo.org/forum/forums/new-users-please-start-here.14/

With regard to your question turn your data into a Table, selected your data, go to Insert > Table, then when you add to the table the chart is updated automatically

 

[chronot]

Hello Oldchippy, thank you very much for your answer, I thought this was the appropriate place to write because my question is related to data label.

How can Excel add for me data label for the last data automatically when I enter new information and delete the data label from the previous day?

Thanks a lot for your help

 

[oldchippy]

Hi,

With regard to your question turn your data into a Table, selected your data, go to Insert > Table, then when you add to the table the chart is updated automatically

Doesn't that do it for you? You can also delete a line from the Table for the previous day.

 

[chronot]

I can't delete because I want to see the trend from the beginning of a certain month until now

 

[Debraj]

Hi Chronot,

Welcome to the forum.. Yes I agree with @oldchippy .. that you should go for new Post and if this post is somehow related to your query.. you can refer a link toi this post..

By the way, in the menawhile.. please take a look.. at the attahcment..

I think VBA work best in this case.. but may be some visulaization guru.. will help you in Non-VBA approach..

Sub ApplyLatestLabel()
ActiveSheet.Shapes("Gráfico 2").Select
  Dim mySrs As Series
  Dim iPts As Long
  Dim bLabeled As Boolean
  For Each mySrs In ActiveChart.SeriesCollection
  bLabeled = False
  With mySrs
  For iPts = .Points.Count To 1 Step -1
  If bLabeled Then
  On Error Resume Next
  mySrs.Points(iPts).HasDataLabel = False
  On Error GoTo 0
  Else
  On Error Resume Next
  mySrs.Points(iPts).ApplyDataLabels _
  ShowValue:=True
  bLabeled = (Err.Number = 0)
  On Error GoTo 0
  End If
  Next
  End With
  Next
End Sub

 

[chronot]

OOOHH Excellent explanation Debraj, that's exactly what I am looking for, wonderful!!!! Thanks a lot!!

 

[chronot]

How can I copy the macro to other workbooks where I have several sheets with charts?

 

[chronot]

Is it possible, Debraj, to put the chart in a new worksheet only and the button that updates the label in another worksheet? Thank you very much for your help