show last x-axis label

I have a time series chart for financial years 1989-90 to 2015-16 inclusive. I would like the x-axis labels to show the most recent data point, i.e. 2015-16, but there is no interval between x-axis labels I can set which will display the label for the most recent observation. Is there a way to adjust the x-axis labels so that the last point is always shown, rather than the first?

Hi there,

Please follow the steeps:

To change the text of category labels in the source data on the worksheet:

Click each cell in the worksheet that contains the label text you want to change.

Type the text you want in each cell, and press Enter.

As you change the text in the cells, the labels in the chart are updated.

To keep the text in the source data on the worksheet the way it is, you can enter new label text that's independent of the worksheet data:

Right-click the category labels you want to change, and click Select Data.

In the Horizontal (Category) Axis Labels box, click Edit.

In the Axis label range box, enter the labels you want to use, separated by commas.

For example, type 2016, 2015, 1990 , 1989.

Hope this can help you !

thanks Trustee
the axis label range box seems to only accept a range, but I can manipulate the source labels as you suggest. Thanks for the tip!