I am trying to create a clustered column graph with an average line running horizontally through it, displaying the average value of the totals of column D. As my spreadsheet shows, I am able to create the date vs totals ok, but I can’t get the average line. In theory the average line (currently 68 as per cell H3), so there should be a horizontal line running through this graph at 68. I think to do this I need to insert a clustered column-line template, but I can’t find this option in the insert-recommended charts-all charts (see screen snapshot). I am using excel 2013 and as far as I know, I am supposed to have the clustered column-line template, but I can’t find it! Am I overlooking something here? Please advise. Many thanks

Attached Images

insert chart display.jpg (136.7 KB, 15 views)

Attached Files

practise sheet.xlsx (16.2 KB, 10 views)