ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   X Axis Limit (https://www.excelbanter.com/charts-charting-excel/154153-x-axis-limit.html)

Alectrical

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

David Biddulph[_2_]

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




Alectrical

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





David Biddulph[_2_]

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







Alectrical

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








All times are GMT +1. The time now is 05:22 PM.

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