Cell/X Axis Issue

[Brandon Plank]

My chart pulls data from another spreadsheet and populates the chart.

The X axis pulls 2 cells and one has each word in it, i.e. one cell has
'Facility' and the other has 'Complaint'.
On the other spreadsheet, the cells are one above the other like:
Facility
Complaint

The issue is that the word 'Facility' ends up being perpendictular to
'Complaint' in the axis and I would like to have them both horizontal.

This is a screenshot so you have an idea what I'm talking about:
http://i41.tinypic.com/fc8x6x.jpg

 

[Shane Devenshire]

Hi,

If you use Excel's default axis for both lables there is nothing you can do
to change the alignment. However, if you create a dummy Y axis and associate
one set of labels with that and the other with the real Y axis you can get
what you need.

Jon Poltier has samples of dummy axes:

http://peltiertech.com/Excel/Charts/