Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line chart categoray axis labels issue - Excel 2007 | Charts and Charting in Excel | |||
Using a cell reference as the axis value for Horizontal axis crosses | Charts and Charting in Excel | |||
XL Axis label formatting issue | Charts and Charting in Excel | |||
Primary Axis(X) Formating Issue | Charts and Charting in Excel | |||
Time on the X Axis Issue | Charts and Charting in Excel |