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