How do I get multilevel category labels to appear horizontal?

  • Thread starter Thread starter Chart help needed
  • Start date Start date
C

Chart help needed

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
 
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
 
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
Click to expand...

Is this still true, if that is the case there is no other way than fake it.
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Chart with 2 horizontal axis field (categories) 1
How do I set up horizontal category labels to wrap in ctg space? 4
Scatter Plot Chart with Category 3
data labels in charts 1
Multi-Level Category Labels 1
Dynamically Scale Gantt Chart Time Scale 2
Stacked column chart narrow bars wanted 5
Excel 2007 - How can I switch the data on vertical and horizontal 1

Back
Top