How to show only every nth data label on chart (Excel 2016)?


I have a line chart that displays the revenue of multiple airlines, throughout the period of 2011 to 2016 – with data points plotted quarterly (Q1-Q4, for each year) on the X-axis.

I would like to only show the data labels (on the chart) for Q4 of each year, for each airline. I would like to do this and keep the axis as is. 

Any suggestions will be much appreciated!

Thank you,



By: Beth

Leave a Reply

Your email address will not be published. Required fields are marked *