In the second version of the bar with average line chart, we use a different method for plotting the average line. Instead of putting another series on the secondary axis, we use a trendline to create a vertical line, from top to bottom.
Keep in mind, it takes a little work to make that happen too. However, you will not have to worry about messing with the secondary axes.
Want to see everything, well almost everything on Excel Effects?
How-to guides Charting Excel PowerPoint Quick tips Quiz Snapshots VBA Videos Google courses Python courses Question of the day Tech Tuesday
Chart library Area charts Bar charts Bubble charts Column charts Combo charts Donut charts Line charts Math charts Pie charts Scatter charts Sheet charts Special charts
Excel Effects filing and organizational tools for your digital office needs.
Yearly calendar Monthly calendar Project schedule template Templates
Affiliate stuff – Move up and excel with Excel
