How do I get multilevel category labels to appear horizontal?

Discussion in 'Excel Charting' started by Chart help needed, Jan 3, 2008.

  1. I am creating a large 100% stacked bar chart but my 2nd and third categories
    on my axis appear vertical instead of horizontal is there anyway to change
    this? I am running Excel 2007
     
    Chart help needed, Jan 3, 2008
    #1
    1. Advertisements

  2. Chart help needed

    Andy Pope Guest

    Hi,

    You can not change the orientation of the outer level category labels as you
    require, only the inner most level of labels is affected by the Alignment
    options.

    If you want full control you will have to fake the axis labels with
    additional series and data labels or textboxes.

    Cheers
    Andy


    --

    Andy Pope, Microsoft MVP - Excel
    http://www.andypope.info
    "Chart help needed" <Chart help > wrote in
    message news:...
    >I am creating a large 100% stacked bar chart but my 2nd and third
    >categories
    > on my axis appear vertical instead of horizontal is there anyway to change
    > this? I am running Excel 2007
     
    Andy Pope, Jan 4, 2008
    #2
    1. Advertisements

  3. Chart help needed

    Guest

    On Friday, January 4, 2008 1:36:27 AM UTC-8, Andy Pope wrote:
    > Hi,
    >
    > You can not change the orientation of the outer level category labels as you
    > require, only the inner most level of labels is affected by the Alignment
    > options.
    >
    > If you want full control you will have to fake the axis labels with
    > additional series and data labels or textboxes.
    >
    > Cheers
    > Andy
    >
    >
    > --
    >
    > Andy Pope, Microsoft MVP - Excel
    > http://www.andypope.info
    > "Chart help needed" <Chart help > wrote in
    > message news:...
    > >I am creating a large 100% stacked bar chart but my 2nd and third
    > >categories
    > > on my axis appear vertical instead of horizontal is there anyway to change
    > > this? I am running Excel 2007


    Is this still true, if that is the case there is no other way than fake it.
     
    , May 29, 2013
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. blinko
    Replies:
    1
    Views:
    111
    Jon Peltier
    Nov 17, 2005
  2. avi
    Replies:
    1
    Views:
    204
    Bernard Liengme
    Jul 3, 2006
  3. kaa_63
    Replies:
    4
    Views:
    99
  4. Boris
    Replies:
    3
    Views:
    266
    Jon Peltier
    Dec 5, 2008
  5. Bahareh

    Multilevel pie chart

    Bahareh, Jan 6, 2009, in forum: Excel Charting
    Replies:
    4
    Views:
    136
    Gaj Vidmar
    Jan 7, 2009
  6. Art

    Restoring Horizontal Axis Labels

    Art, Mar 8, 2009, in forum: Excel Charting
    Replies:
    1
    Views:
    93
    Shane Devenshire
    Mar 8, 2009
  7. maria

    Horizontal (Category) Axis

    maria, Mar 30, 2009, in forum: Excel Charting
    Replies:
    6
    Views:
    227
    maria
    Apr 2, 2009
  8. KMCL

    horizontal axis labels

    KMCL, Apr 29, 2009, in forum: Excel Charting
    Replies:
    1
    Views:
    83
    Luke M
    Apr 29, 2009
Loading...