"Sandi" wrote in message
...
How do I get my X axis and Y axis to auto scale inside my chart when I add
new data in my spreadsheet?

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