#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 62
Default X Axis Limit

Hi
I have a chart that expands as the information in two columns grow. I find
that the Y-Axis expands with the information, but the X-Axis is fixed, is
there any way I can get the X-Axis to expand also.

Thanks Alec
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default X Axis Limit

Format Axis/ Scale:
Ensure that the auto box is selected against min & max values.
--
David Biddulph

"Alectrical" wrote in message
...
Hi
I have a chart that expands as the information in two columns grow. I find
that the Y-Axis expands with the information, but the X-Axis is fixed, is
there any way I can get the X-Axis to expand also.

Thanks Alec



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 62
Default X Axis Limit

Hi David

Thanks for your reply.

Sorry that option is not available to me at present, I'm using Excel 2000,
is this option available on later versions, I'm intending to upgrade in the
near future.

Thanks
Alec

"David Biddulph" wrote:

Format Axis/ Scale:
Ensure that the auto box is selected against min & max values.
--
David Biddulph

"Alectrical" wrote in message
...
Hi
I have a chart that expands as the information in two columns grow. I find
that the Y-Axis expands with the information, but the X-Axis is fixed, is
there any way I can get the X-Axis to expand also.

Thanks Alec




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default X Axis Limit

That option has been available since long before Excel 2000. What type of
chart are you using? I assumed that you were using an XY chart.
--
David Biddulph

"Alectrical" wrote in message
...
Hi David

Thanks for your reply.

Sorry that option is not available to me at present, I'm using Excel 2000,
is this option available on later versions, I'm intending to upgrade in
the
near future.

Thanks
Alec

"David Biddulph" wrote:

Format Axis/ Scale:
Ensure that the auto box is selected against min & max values.
--
David Biddulph

"Alectrical" wrote in message
...
Hi
I have a chart that expands as the information in two columns grow. I
find
that the Y-Axis expands with the information, but the X-Axis is fixed,
is
there any way I can get the X-Axis to expand also.

Thanks Alec






  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 62
Default X Axis Limit

Hi David

Thanks for your reply
Actually I was using a line chart, as soon as I changed it to XY I got
better results, I,m testing the chart at present and it seems to be just what
I was after.
Thanks again for your time.

Best Regards
Alec

"David Biddulph" wrote:

That option has been available since long before Excel 2000. What type of
chart are you using? I assumed that you were using an XY chart.
--
David Biddulph

"Alectrical" wrote in message
...
Hi David

Thanks for your reply.

Sorry that option is not available to me at present, I'm using Excel 2000,
is this option available on later versions, I'm intending to upgrade in
the
near future.

Thanks
Alec

"David Biddulph" wrote:

Format Axis/ Scale:
Ensure that the auto box is selected against min & max values.
--
David Biddulph

"Alectrical" wrote in message
...
Hi
I have a chart that expands as the information in two columns grow. I
find
that the Y-Axis expands with the information, but the X-Axis is fixed,
is
there any way I can get the X-Axis to expand also.

Thanks Alec






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
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) Tom Excel Discussion (Misc queries) 1 May 29th 07 01:03 PM
Adding data on Axis Major Gridlines next to Category Axis Collums jblittlejohn New Users to Excel 0 July 10th 05 12:17 PM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM
Nested IF limit or Open parentheses limit Fred Excel Discussion (Misc queries) 5 December 23rd 04 03:34 PM
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another John Smith Charts and Charting in Excel 7 December 21st 04 08:26 PM


All times are GMT +1. The time now is 06:13 AM.

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"