+ Reply to Thread
Results 1 to 3 of 3

Rotate data labels to be vertical

  1. #1
    Registered User
    Join Date
    09-18-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    47

    Rotate data labels to be vertical

    I am trying to figure out a way to rotate data labels to be vertical via VBA. I know how to do it manually, but since this chart is generated from a button I want it to be done within the VBA.

    I have attached an example. I need the correct code to make Sheet1, look like Sheet1 (2).

    Note that the red data labels are not axis', the x axis has been removed from this chart.

    Thanks for any help
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Rotate data labels to be vertical

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-18-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Rotate data labels to be vertical

    That worked great!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Rotate x category labels in a pivot chart.
    By guntherda in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-01-2013, 06:33 AM
  2. Rotate Cell Layout From Horizontal To Vertical
    By aeboi80 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2012, 07:21 PM
  3. [SOLVED] RE: In Excel can I rotate a column from vertical to horizontal.
    By microsoft.public.excel.misc in forum Excel General
    Replies: 0
    Last Post: 06-10-2006, 05:25 AM
  4. [SOLVED] Multiple charts in one big chart -- how to rotate to vertical position?
    By Father Guido in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-01-2005, 08:40 AM
  5. How do I rotate Horazontial cells vertical, so part of the chart .
    By Wendol in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1