Forum Discussion

Billtort's avatar
Billtort
Copper Contributor
Nov 22, 2019
Solved

Adding primary axis bar and adding secondary axis label

Where did the vertical axis bar go in Excel for Mac 16.31. All it has now are the horizontal grid lines. Is there any way to turn them on? Also, I can't find how to add a secondary axis label. The solutions on the support pages don't help. Thanks!

  • Billtort 

    Okay. Clear now. Was a bit confused.

     

    Click on either axis and choose Format Axis. There you can select the bucket icon and determine what kind of line you want (e.g. solid, black, 0.5pt wide, etc.)

      

15 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    Billtort 

    Please upload a file with you chart. Am on a Mac myself but don't understand you question. Perhaps when I (or any other Mac user) can have a look at it, we can help.

    • Billtort's avatar
      Billtort
      Copper Contributor

      Riny_van_EekelenThanks for your rapid response. Here's the most recent figure I'm having the problem with. I've drawn in yellow where the vertical axis bar should go and added in red the Axis label I want to add. There are no options for adding either anywhere in the Add Chart Element drop down menu while the axis is selected.

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor

        Billtort

         

        Thanks. But where is your data? You seem to have everything hardcoded in arrays in your data series. And what would you like to show in the vertical axis (both yellow and red)?

         

        Perhaps I'm not grasping what you are asking for. Sorry.

Resources