I cant find my clustered column line template?
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
|