Line chart with points of interest

[RockandGrohl]

Hello all,

Is it possible to create a line chart with points of interest? Let's say I use this data:

Day	Bookings	Event
1/1/2019	78
2/1/2019	320	HH Mailer
3/1/2019	160
4/1/2019	290	JV2 Mailer
5/1/2019	300
6/1/2019	140
7/1/2019	230	WE Email

<tbody>
</tbody>

So I'd have a line chart as you expect, but I want to have markers on it so I can try and correspond the events to the dates and hopefully draw a pattern that a mailing or email results in more bookings on the line chart.

I'm getting stuck with A) Having all dates across the screen instead of a compressed 1st, 4th, 7th, 10th etc view, and B) Actually putting the labels in.

Ideally I'd want them labelled across the top, aligned with the date and then a marker on the actual line itself.

Any ideas if this is possible? Thanks.

 

[James006]

Hi,

Difficult to help you out with tailor-made solution without access to your file ...

Most probably ... you will find your own solution with some inspiration ...

See Andy's excellent site : https://andypope.info/charts/Hilolabel.htm

Hope this will help

 

[RockandGrohl]

Hi,

Difficult to help you out with tailor-made solution without access to your file ...

Most probably ... you will find your own solution with some inspiration ...

See Andy's excellent site : https://andypope.info/charts/Hilolabel.htm

Hope this will help

This looks really close to what I want, I'll have a play, thank you!

 

[James006]

You are welcome ...

 

[Dave Paradi]

Another option is to use an invisible line to position the points of interest text like this:

The EventLine data series values are 1.15 * the values for the Bookings so that the text is above the data labels for the Bookings. The EventLine series is a regular line chart set to No Color to make it invisible and the data labels are from cells D2:D8. This way the Event text always lines up with the correct date and the text moves if the values change.

Hope that gives you another option to consider.