Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6
Default 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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Colour plot area of a dual axis x,y chart nobbyknownowt Charts and Charting in Excel 3 September 19th 08 04:25 PM
How to align the category axis to plot area awrex Charts and Charting in Excel 6 November 4th 06 12:52 PM
How to increase chart area without affecting plot area? [email protected] Charts and Charting in Excel 2 April 21st 06 09:05 PM
Resize chart area without resizing plot area Janwillem van Dijk Charts and Charting in Excel 2 August 2nd 05 01:52 AM
How do I move the Category Axis labels outside of the Plot Area? Brian Shoun Charts and Charting in Excel 1 January 7th 05 05:42 PM


All times are GMT +1. The time now is 09:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"