Adding an Average reference line to a bar chart

[#1]

Hi,

I need to create a similar chart like the one attached.

The issue I have is displaying a vertical line which indicates the average duration value.

I found in the forums tips about using a reference line. But the issue is that it is horizontal.

Your help is highly appreciated.

Thanks!

[#2]

Is this what u need: http://community.qlik.com/thread/45463 ?

[Gysbert_Wassenaar]

The x-axis needs to be continuous to make it possible to add a vertical reference line. See attached example.

[#4]

Hi,

I can't open your file, because I have a personal edition.

But after definining the Continuous, it's still didn't help.

BTW, I'm using Class for the dimension, but it was overriden by the Continuos.

Thanks!

[Gysbert_Wassenaar · Accepted solution]

If you have continuous X axis you can add a vertical reference line by choosing Continous X as location:

[#6]

Now I got it! Thanks!

The only issue left is that I can't use the class display range.

(If I disselect the Continuous from the Axes tab).

Is there a workaround to have both?