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

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

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: