How to add event labels in charts?

[hizzle]

For the life of me I just can't figure this out... (Excel 2003)
What I have is weekly sales data for a product for a couple years (a quantity for each Sunday). I also have press release titles and dates they were published.

What I am trying to do and I can't quite figure out, is how to make a chart (line graph) of the data, and then have the title of each press release on the chart and point it to the data line of quantities at the appropriate date (which may or may not be a Sunday. Essentially so I can see if the press releases have any effect.

I don't know if there is a way to do this, and have the chart be able to be updated so I can just keep adding weekly sales data and also press releases.

Thanks!

 

[tusharm]

Put the press release title and date in the appropriate cell in a column adjacent to the one plotted in the chart. Now, use an add-in like Rob Bovey's XY Chartlabeler to associate this new column as the source for the data labels for your chart.

 

[hizzle]

Very helpful.
One additional question I should have noted - would you happen to know any way to "tie" the event label (aka a press release) to the data point by creating a line between the two? The press releases have bit longer names (though I could shorten them if there is no solution) so it would be great to be able to move the label but still indicate to what data point it is referring.
Thanks much!

 

[tusharm]

Unfortunately, no, no leader lines except in a pie chart.

You could force the label into multiple lines with ALT+ENTER. For example, to put "This is a long, long, long, long, event label" on two lines, enter in the cell containing the event label: This is a long, long, long, ALT+ENTER long, event label ENTER

Very helpful.
One additional question I should have noted - would you happen to know any way to "tie" the event label (aka a press release) to the data point by creating a line between the two? The press releases have bit longer names (though I could shorten them if there is no solution) so it would be great to be able to move the label but still indicate to what data point it is referring.
Thanks much!