Thread: Urgent - X and Y Axis Auto Scale for Chart

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

"Sandi" <Sandi@discussions.microsoft.com> wrote in message
news:E4D8613F-13C3-4C1B-9576-95E44B0AE156@microsoft.com...
> 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

That works for my Y axis but I also need my X axis to auto scale also.
--
Sandi Gardner


"David Biddulph" wrote:

> "Sandi" <Sandi@discussions.microsoft.com> wrote in message
> news:E4D8613F-13C3-4C1B-9576-95E44B0AE156@microsoft.com...
> > 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
>
>
>

"Sandi" <Sandi@discussions.microsoft.com> wrote in message
news:4D4B5FEA-AD56-46F6-9961-9D9231C59E08@microsoft.com...

> "David Biddulph" wrote:
>
>> "Sandi" <Sandi@discussions.microsoft.com> wrote in message
>> news:E4D8613F-13C3-4C1B-9576-95E44B0AE156@microsoft.com...
>> > 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.

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

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.
--
David Biddulph