If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cell/X Axis Issue
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 |
#2
|
|||
|
|||
Cell/X Axis Issue
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/ -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Brandon Plank" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|