Chart with average line in Excel
Right click the average column. From the list choose the Change Series Chart Type option.
Choose Line Chart.
Average Line is ready.
This is it. Average line on the chart could be useful to compare data with an average value.
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References