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:


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Day[/TD]
[TD]Bookings[/TD]
[TD]Event[/TD]
[/TR]
[TR]
[TD]1/1/2019[/TD]
[TD]78[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2/1/2019[/TD]
[TD]320[/TD]
[TD]HH Mailer[/TD]
[/TR]
[TR]
[TD]3/1/2019[/TD]
[TD]160[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4/1/2019[/TD]
[TD]290[/TD]
[TD]JV2 Mailer[/TD]
[/TR]
[TR]
[TD]5/1/2019[/TD]
[TD]300[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6/1/2019[/TD]
[TD]140[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/1/2019[/TD]
[TD]230[/TD]
[TD]WE Email[/TD]
[/TR]
</tbody>[/TABLE]


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.