X Axis Limit

A

Alectrical

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
 
D

David Biddulph

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

Alectrical

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
 
D

David Biddulph

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.
 
A

Alectrical

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding asymptote equation and how to draw them in excel 0
Make Y-axis values correspond to x- axis value 1
Comparative Scatterplot?? 1
simple chart 0
Gantt chart duration not showing 0
Scatter chart with categories on x-Axis 2
Use text descriptors as Y axis units 1
Excel 2010 - Line Chart with Mulitiple Data Sets 1

Top