How to add event labels in charts?

hizzle

New Member
Joined
Apr 30, 2004
Messages
26
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!
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
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

New Member
Joined
Apr 30, 2004
Messages
26
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

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
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

hizzle said:
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,763
Messages
5,574,096
Members
412,567
Latest member
mm1
Top