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
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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> "David Biddulph" wrote:
>
>> "Sandi" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks