Adding second horizontal axis

Question

Hi All, 

I am looking to add a second horizontal axis below the dates that state the month i.e. for the first few 5/3, 5/10, 5/17 I would like to put May underneath them in the center. Can someone please advise in detailed steps how to do? 

 

Answer 1

Hi SouthATL_992, 

As you mention you want to put MAY underneath in the center, we would like to suggestion you as a workaround you try my step below, hope it meet your goal.

To add a second horizontal axis, you first need to add a second vertical axis(only then will the options of second horizontal axis get activated).

After Choose Secondary Axis now, click anywhere is graph. This will enable Design tab. Under Design tab > Add Chart Elements > Axes Title> second horizontal and test box will appear in center of chart then write the name MAY.

 

Let us know if you need further assistance.

Best Regards,

Waqas Muhammad

Answer 2

Hi,

I am an independent advisor, and I am trying to help other users in the Community with my experience with Microsoft products.

Please use this following article about to add second horizontal axis in Excel.

https://support.office.com/en-us/article/add-or...

Hope this help.

Do let me know if you have any more question or require further help.

Thanks and regards

Answer 3

Hello, 

This does not help. The video add a secondary vertical axis on the opposite side of the graph. I am looking to add a horizontal axis under the current horizontal axis. Can you advise on how that can be done? 

Thanks!

Answer 4

Hello,

Thanks for writing back.

Please check the response of this forum and follow the steps listed there. The problem seems similar to yours so it can help you.

https://superuser.com/questions/188064/excel-ch....

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

Thanks again for following up and let me know if any issue occurs.

Answer 5

Hi SouthATL_992, 

Have you checked my above reply? Do you need further assistance?

Best Regards,

Waqas Muhammad