View Single Post
 
Old 09-15-2020, 05:01 PM
oscarlimerick oscarlimerick is offline Windows 8 Office 2013
Novice
 
Join Date: Jul 2020
Posts: 13
oscarlimerick is on a distinguished road
Default 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
Attached Images
File Type: jpg insert chart display.jpg (136.7 KB, 9 views)
Attached Files
File Type: xlsx practise sheet.xlsx (16.2 KB, 4 views)
Reply With Quote