How to link comments to a particular point in an excel chart

Hi,I would like to populate comments on to an Excel line chart that help annotate the story it tells.

 

The chart has time along the X-axis and the values of variable along the Y-axis. These values come from a standard two column table.

My current process is to manually add text boxes with arrows pointing to each point on the chart however whenever I update the time axis the line graph shifts along and the manually added text boxes are out of synch.

My thought of a solution is to add a third column to the source table and against the row where a comment is needed add my words to the third column. I need your help please on a way that I could get the comments from the source table to populate in a linked text box box to the line chart. I am guessing this needs a macro as I can’t see any obvious functionality within excel to do it.

By: Paul

565 thoughts on “How to link comments to a particular point in an excel chart

  1. Baixar Painel Iptv Apk

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  2. tali id card

    My partner and i would like to demonstrate thanks to you merely for bailing me out there of this particular difficulties. As a result associated with checking throughout the net and even meeting techniques that have been not productive, I think my personal life was done.

  3. 출장

    Thanks , I have just been looking for info about this topic for ages and yours is the greatest I have discovered so far. But, what about the bottom line? Are you sure about the source?

  4. lantai vinyl

    Please let me understand if you’re searching for a good author for your web site. You might have some great articles, and I think I would personally be a good property. Should you ever want to acquire some of the fill off, I’d like in order to write some material regarding your blog in change to get a link back in order to mine. Please shoot myself an email if serious. Thanks.

Comments are closed.