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_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.
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.
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!
