Forum Discussion
Billtort
Nov 22, 2019Copper Contributor
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!
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
Sort By
- Riny_van_EekelenPlatinum Contributor
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.
- BilltortCopper 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_EekelenPlatinum Contributor
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.