ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   X-Axis Appearing in Plot Area (https://www.excelbanter.com/charts-charting-excel/245002-x-axis-appearing-plot-area.html)

Mike M.[_2_]

X-Axis Appearing in Plot Area
 
I've created a line graph with 3 different series - one of the series is
converted to columns. I have a Primary and a Secondary Y-axes. The plotted
values are relatively small - ranging from 2.00 down to -0.23 (negative).
The x-axis shows 4 points in time (Apr-09 / Oct-09 / Apr-10 / Oct-10).

The 4 labels on the x-axis appear fine - below the plot area. The problem
is that the x-axis itself appears IN the plot area - not below it. I
adjusted the alignment of the labels - hoping to get the axis to move below
the plot area - didn't work. I tried adjusting the values on each of the two
Y-axes - still no good - x-axis still appears in the plot area instead of
below it.

Any assistance would be greatly appreciated.

Thanks,
Mike M.

David Biddulph[_2_]

X-Axis Appearing in Plot Area
 
Format Axis/ Scale/ Category (X) axis crosses at ...
--
David Biddulph

"Mike M." wrote in message
...
I've created a line graph with 3 different series - one of the series is
converted to columns. I have a Primary and a Secondary Y-axes. The
plotted
values are relatively small - ranging from 2.00 down to -0.23 (negative).
The x-axis shows 4 points in time (Apr-09 / Oct-09 / Apr-10 / Oct-10).

The 4 labels on the x-axis appear fine - below the plot area. The problem
is that the x-axis itself appears IN the plot area - not below it. I
adjusted the alignment of the labels - hoping to get the axis to move
below
the plot area - didn't work. I tried adjusting the values on each of the
two
Y-axes - still no good - x-axis still appears in the plot area instead of
below it.

Any assistance would be greatly appreciated.

Thanks,
Mike M.




Mike M.[_2_]

X-Axis Appearing in Plot Area
 
Awesome!! Worked like a champ. Thanks.

Mike M.

"David Biddulph" wrote:

Format Axis/ Scale/ Category (X) axis crosses at ...
--
David Biddulph

"Mike M." wrote in message
...
I've created a line graph with 3 different series - one of the series is
converted to columns. I have a Primary and a Secondary Y-axes. The
plotted
values are relatively small - ranging from 2.00 down to -0.23 (negative).
The x-axis shows 4 points in time (Apr-09 / Oct-09 / Apr-10 / Oct-10).

The 4 labels on the x-axis appear fine - below the plot area. The problem
is that the x-axis itself appears IN the plot area - not below it. I
adjusted the alignment of the labels - hoping to get the axis to move
below
the plot area - didn't work. I tried adjusting the values on each of the
two
Y-axes - still no good - x-axis still appears in the plot area instead of
below it.

Any assistance would be greatly appreciated.

Thanks,
Mike M.






All times are GMT +1. The time now is 04:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com