Urgent - X and Y Axis Auto Scale for Chart

S

Sandi

How do I get my X axis and Y axis to auto scale inside my chart when I add
new data in my spreadsheet?
 
D

David Biddulph

Sandi said:
How do I get my X axis and Y axis to auto scale inside my chart when I add
new data in my spreadsheet?
Click to expand...

The default is to do so.
Check Format Axis/ Scale, and ensure that Auto is ticked for Min & Max.
 
D

David Biddulph

That works for my Y axis but I also need my X axis to auto scale also.
Click to expand...

Do the same for the X axis. If it isn't working for you, you're probably
using the wrong type of chart.

X-Y chart is normally the best bet if you're interested in the X axis data
rather than merely category labels.
 

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

Make Y-axis values correspond to x- axis value 1
simple chart 0
Finding asymptote equation and how to draw them in excel 0
Scatter chart with categories on x-Axis 2
multi dimension/axis single series bar chart 0
Gantt chart duration not showing 0
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1

Top