Forum Discussion
Adding primary axis bar and adding secondary axis label
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.)
  
Riny_van_EekelenRiny- Here's the figure with the data. I want to be able to generate a black vertical line like graphs are supposed to have where I placed the yellow line (that used to be the default, now that's gone and there seems to be no way to turn the option back on). And I want to be able to enter an secondary axis label on the right side where I entered the text in red. There used to be an option to label the secondary axis, but I can't remember or find where to add that option.
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.)
  
Riny_van_EekelenRiny- Thank you for your response, however, I want Excel to automatically draw the primary vertical axis bar, not hand drawn by me. It used to do that as the default. 99 % of figures in scientific literature use a solid X and Y axis bar rather than the horizontal bars at various intervals that is now the default in Excel. That style is rarely used in scientific papers. I've attached an image of one such chart that was generated by Excel. Sorry for being a pest!
Riny_van_EekelenIGNORE MY LAST POST. Your suggestion does works! THANK YOU! Now, is there any way of making this the default for all my charts? Also, the second part of my question was about adding a Secondary Axis Title. I still can't find how to do this.
I guess SergeiBaklan answered that question 🙂
As variant you may generate your own templates and use them for new charts https://support.office.com/en-us/article/save-a-custom-chart-as-a-template-259a5f9d-a9ec-4b3f-94b6-9f5e55187f2a#ID0EAABAAA=macOS
Thank you, SergeiBaklan, that's a great help!
