Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Simple question- how to make X axis on bottom of chart
Hi, pretty self explanatory, and probably a quick fix. Basically my data in my chart varies between -5 and -15 on the y axis. As a result the X axis labels appear at the top of the chart, and not the traditional way at the bottom. I would like them to be at the bottom, and i'm sure it must be a quick fix. Any one know how to do it? Thanks, Joel -- Boon8888 ------------------------------------------------------------------------ Boon8888's Profile: http://www.excelforum.com/member.php...o&userid=30647 View this thread: http://www.excelforum.com/showthread...hreadid=509455 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Simple question- how to make X axis on bottom of chart
Right click y-axis; format
open Scale tab and set Crosses X axis at -15 (or -20 if you prefer) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Boon8888" wrote in message ... Hi, pretty self explanatory, and probably a quick fix. Basically my data in my chart varies between -5 and -15 on the y axis. As a result the X axis labels appear at the top of the chart, and not the traditional way at the bottom. I would like them to be at the bottom, and i'm sure it must be a quick fix. Any one know how to do it? Thanks, Joel -- Boon8888 ------------------------------------------------------------------------ Boon8888's Profile: http://www.excelforum.com/member.php...o&userid=30647 View this thread: http://www.excelforum.com/showthread...hreadid=509455 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Simple question- how to make X axis on bottom of chart
An alternative leaves the axis line and ticks at zero but moves the labels
out of the way. Right click the X axis, select Format, and on the Patterns tab, choose the Low option for Tick Labels. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Bernard Liengme" wrote in message ... Right click y-axis; format open Scale tab and set Crosses X axis at -15 (or -20 if you prefer) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Boon8888" wrote in message ... Hi, pretty self explanatory, and probably a quick fix. Basically my data in my chart varies between -5 and -15 on the y axis. As a result the X axis labels appear at the top of the chart, and not the traditional way at the bottom. I would like them to be at the bottom, and i'm sure it must be a quick fix. Any one know how to do it? Thanks, Joel -- Boon8888 ------------------------------------------------------------------------ Boon8888's Profile: http://www.excelforum.com/member.php...o&userid=30647 View this thread: http://www.excelforum.com/showthread...hreadid=509455 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't make secondary axis in bar chart | Charts and Charting in Excel | |||
How to make "secondary x axis labels" | Charts and Charting in Excel | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |