More Horizontal Axis Labels

[RedMan7]

Hello All,

I hope you can help me. I have a graph, and I have dates as the axis labels (horizontal axis) - I am struggling to find a way to add more axis labels (more dates) along the horizontal axis. Do you have any advice on how to do this?

Do you have any further tips to format the graph I have? based on the fact that it is a date-contingent graph?

Thank you!

Here is the picture
https://unsee.cc/149cff37/

 

[ClaireS]

Have you tried turning on Minor Type tickmarks in the Axis Formatting, Tick Marks section? It always irritates me that you need to do this even after defining your minor tickmark settings under Axis Options.

NB I'm using Excel 2016/365. Charting was changed massively between 2010 and 2013, so if you're on an earlier version, this may not work anyway!

Good luck

 

[RedMan7]

Claire,

Thanks for your reply. I'm not talking about the tickmarks, I'm talking about the Labels themselves - I can't find an option to add more frequent labels - i.e. a label for every tickmark. Do you know how to do this?

Thanks.

 

[RedMan7]

If you actually look at the image I posted, the major and minor tickmarks are already turned on

 

[ClaireS]

Sorry, I was working on a dummy file of mine and thought I was labelling minor tickmarks, but evidently I wasn't.

You might be able to do it if you create a dummy data range with the dates you want to use as labels, then a small value e.g. 1 beside each. Plot this as a second series, as an X-Y scatter chart. Then show data labels.

A couple of examples:
https://www.mrexcel.com/forum/excel-questions/498453-chart-minor-gridlines.html
https://www.excelforum.com/excel-charting-and-pivots/840693-minor-tick-mark-labels-in-charts.html

Good luck!

 

[RedMan7]

Hi Claire,

I figured it out in the end - I had to use combined graphs.
I did post a new thread, I am hoping you might be able to help me with this?

https://www.mrexcel.com/forum/excel-questions/1094456-updating-comments-textbox-vba.html

Thanks again!

 

[ClaireS]

I'm really glad you were able to get it sorted, and happy that I was able to point you in the right direction. I have made a suggestion on your new thread too.