locked
Vertical Axis Title Issue RRS feed

  • Question

  • Dear Sir:

    I used ".SetElement (msoElementPrimaryValueAxisTitleAdjacentToAxis)" to add vertical axis adjacent title. It didn't show any error when I debugged it. But it didn't add vertical axis title.

    When I used ".SetElement (msoElementPrimaryValueAxisTitleVertical)" to add vertical axis title. It did add the vertical axis title. But it wasn't what I wanted.

    Is there a way to make ".SetElement (msoElementPrimaryValueAxisTitleAdjacentToAxis)" work? Your support is highly appreciated!

    Regards,

    Shell Hu

    Friday, November 18, 2016 1:35 PM

Answers

  • Does msoElementPrimaryValueAxisTitleRotated do what you want?

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Shell Hu Friday, November 18, 2016 11:03 PM
    Friday, November 18, 2016 6:40 PM

All replies

  • Does msoElementPrimaryValueAxisTitleRotated do what you want?

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Shell Hu Friday, November 18, 2016 11:03 PM
    Friday, November 18, 2016 6:40 PM
  • This seems to be a bug in excel.
    Sunday, October 1, 2017 9:03 AM