Urgent - X and Y Axis Auto Scale for Chart

G

Guest

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

Horizontal axis to the bottom 1
Auto Scale x-axis 1
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1
X-axis in 2007 4
Scale on X & Y Axis of the scatter chart 3
Using a 'Name' to Update Chart Titles & "Y" Axis Scale 2
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
Data labels along below x axis when y axis has negative values 1

Top