Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Increasing X-axis Offset for graphs cutting x-axis
Hi,
I have a graph which has bars above x-axis and below x-axis as well (Positive and negative values - percentages- being plotted). My Values / Bars may range from +100% to -100%. I see that the X-axis offset feature (within alignment) has maximum value of 1000 and I want to display my value labels below the x-axis. Problem is if I scale my y-axis from -100 to +100 then the bars cross over my value labels. On the other hand If I scale the graph to a -300 to +300 then though the bars dont cross over my value labels the graph appears very very small. Is there some way one can tamper with the X-axis offset feature limit of 1000 because if it could be increased then my problem could be solved. Or if there is any other way then please guide me. Thanks a lot, Hari India |
#2
|
|||
|
|||
Hi,
This should help explain how to move the xaxis labels away from your columns. http://www.andypope.info/tips/tip002.htm Cheers Andy Hari Prasadh wrote: Hi, I have a graph which has bars above x-axis and below x-axis as well (Positive and negative values - percentages- being plotted). My Values / Bars may range from +100% to -100%. I see that the X-axis offset feature (within alignment) has maximum value of 1000 and I want to display my value labels below the x-axis. Problem is if I scale my y-axis from -100 to +100 then the bars cross over my value labels. On the other hand If I scale the graph to a -300 to +300 then though the bars dont cross over my value labels the graph appears very very small. Is there some way one can tamper with the X-axis offset feature limit of 1000 because if it could be increased then my problem could be solved. Or if there is any other way then please guide me. Thanks a lot, Hari India -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Hi Andy,
Thats been a great help. Thanks a lot, Hari India "Andy Pope" wrote in message ... Hi, This should help explain how to move the xaxis labels away from your columns. http://www.andypope.info/tips/tip002.htm Cheers Andy Hari Prasadh wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel |