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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Chart and X axis..colour challanging Question...it seems..!!!! | ismail | Setting Up & Running Reports | 0 | August 29th, 2005 06:05 PM |
Simple TimeScale Chart Question | MrMike | Setting Up & Running Reports | 0 | May 25th, 2005 03:01 PM |
How do I make the Y axis in an excel chart the category axis? | megnadoodle | Charts and Charting | 2 | March 29th, 2005 09:27 AM |
P & V chart: Secondary X axis gradient (again) | wlotto | Charts and Charting | 9 | March 15th, 2004 05:26 PM |
Simple pie chart question | Jim Meyer | Charts and Charting | 2 | October 6th, 2003 05:34 PM |