X-axis labelling

Good morning,

Apologies if this has been asked before, but I could not see a thread relating to it.

I have a data series containing 366 values (call volumes for 2020) and I cannot figure out how to edit the x-axis labels so that they only show the months of the year instead of every day of the year.

The X-axis looks a bit crowded and is difficult to read, so just having the months listed would be the preferred option.

Any assistance would be greatly appreciated.


Thanks in advance,
Peter

Hi MrShorty,

Thank you for your response and assistance.

The graph generated is a line graph, so your fix should work.

I'll give it a go shortly and will let you know if I encounter any further issues.


Your help is very much appreciated.


Kindest regards,
Peter

Thanks again,

The issue is that I have each day of 2019 & 2020 with associated data. They are currently in the dd/mm/yyyy format.

I need to change these to read the Irish language version. This is not a problem, but when I amend the date range from dd/mm/yyyy to dd/mmmm/yyyy in Irish,
I don't seem to have the same Format Axis options that I did before I edited the dates.

I have attached a copy of the spreadsheet for reference.

There are 2 graphs, I need to insert the 2nd one into a report, but want the x-axis on that to look the same as the x-axis on the 1st graph (just in Irish, not English)


I was sent these graphs by an outside organisation, so am not familiar with the formatting, etc. that they might have used.


It's a new role for me where I work, so want to make a good impression........as you do


Again, any assistance would be greatly appreciated.


Regards,
Peter