Adding Average Lines to Trellis

[Anonymous]

Hi Everyone,

I'm creating a trellis line chart which a tracks a value year over month. I'd like to add a line indicating the average value per year to each section of the trellis chart. I've tried following this solution:

Reference lines for each section of the trellis chart

I've attached a small application as an example. I can calculate the correct yearly average, however I'm not able to extend that value to all months in the given year. I would like my chart to look like the below image.

Thanks!

Michael

[Anonymous]

do you want to achieve 12 separate  data points for 2014?

[Anonymous]

Yes, I believe that's what I want. As long as the average line extends across all months for each year.

[Anonymous]

could you add your excel file please, I think you'll have to add the missing values at script level

[Anonymous]

Here it is. Thanks.

[Anonymous]

not sure, if 100% correct, but I think the basic idea should be clear ...

[Anonymous]

or use a separate calendar....

[Anonymous]

Thanks for the suggestions Robin. Is there any way to calculate the averages without changing the script? I was hoping this could be done by writing an expression.

Thanks

[Anonymous]

I don't think that it is possible without changing the script because the values just don't exist for 2014...

(could be that  I am wrong )

For this chart type there's no "populate missing" option as it exists for pivot charts.