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!
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!