H
hizzle
I've been trying to do this for a bit and can't seem to find a way.
I am trying to do a line chart of weekly sales for two product lines
over several years (2 separate lines).
What I would like to do is overlay labels for press releases (so you
can see if they have an impact on sales) on the same chart, and have a
line from the name of the press release to the correct corresponding
point on the line chart that is "active", so as more points are added
to the chart, the line indicating the unit corresponding to the date of
the press release will move also.
Additionally, the press release dates may be different dates from the
weekly sale dates.
I can figure out how to do this on separate charts, but not the same
one (I have tried using XY chartlabeler, which helps, but doesn't allow
me to drag the labels around to make the charts more readable and have a
line to show what point the press release is referring to).
Any help is appreciated. Thanks!!
I am trying to do a line chart of weekly sales for two product lines
over several years (2 separate lines).
What I would like to do is overlay labels for press releases (so you
can see if they have an impact on sales) on the same chart, and have a
line from the name of the press release to the correct corresponding
point on the line chart that is "active", so as more points are added
to the chart, the line indicating the unit corresponding to the date of
the press release will move also.
Additionally, the press release dates may be different dates from the
weekly sale dates.
I can figure out how to do this on separate charts, but not the same
one (I have tried using XY chartlabeler, which helps, but doesn't allow
me to drag the labels around to make the charts more readable and have a
line to show what point the press release is referring to).
Any help is appreciated. Thanks!!