Adding an average line to an existing column chart

[Ed]

I've got a column chart with a single series.  I am trying to add an average line to it.  So, let's say the column chart has 5 data points [10, 20, 30, 20, 30] and shows 5 columns on the chart.  The average is 22.  Do I really need to have the average data be [22, 22, 22, 22, 22], which will put a circle for each data point on the line?  Ideally, I'd like a single horizontal line across the chart without any data points showing up (while still having the data points on the columns show up so I can do hover).  Hmmm, it would be nice to still have the hoverable capability on the average line so the user can see the exact value.
What are my options here?
Thanks,
--Ed

[Iliana Dyankova]

Hi Ed,

In order to achieve the desired result I can suggest the following two approaches:

• Add an additional line series and hide the markers (jsBin example);
• Set valueAxis plotBands (updated jsBin example). Keep in mind in this case the hoverable capability is not available.

Regards,
Iliana Nikolova
Telerik

[Ian]

Iliana, both of your examples use plot bands. Can you provide an example which uses a line series as you suggested? Thanks

[Iliana Dyankova]

Hi Ian,

I apologize for the mistake - here is the jsBin with the additional line series. 

Regards,
Iliana Nikolova
Telerik

[Chuen]

I also had similar requirement before.  I can't use the line series because the line doesn't touch the y-axis, so I ended up using the plotband.  But the plotband solution is not perfect.  In most situation, I ended up with different line thickness when the scale of the data changes.