Excel Charting (XP)

Topic

New Reply

I’m trying to create a price chart in Excel. Is it possible to add comments/annotations to the price chart on specific dates. And maybe point those comments to the corresponding dates using an arrow? Is it possible or do I need an additional add-in?

Thanks in advance for all the help.

Reply | Quote

Replies

You can use the drawing tools in Excel to draw text boxes and arrows. Have you used the drawing tools before?

Cheers

Reply | Quote

After a line chart or XY scatter chart is drawn, it’s possible to select an individual point, turn on data labels for just that point and turn those data labels into “comment boxes.” The boxes usually need to be moved for legibility and if data is added or changed, may have to be “redrawn”. I did work at a place that developed a macro for commenting boxes precisely for price charts, but no longer recall specifics. I’ve attached a very short example. As mentioned above, it usually easiest to draw arrows using the draw toolbar, once the points have been marked

Reply | Quote

This is really helpful. Thanks for the help guys!!!

Reply | Quote