ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Urgent - X and Y Axis Auto Scale for Chart (https://www.excelbanter.com/charts-charting-excel/92935-urgent-x-y-axis-auto-scale-chart.html)

Sandi

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

David Biddulph

Urgent - X and Y Axis Auto Scale for Chart
 
"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



Sandi

Urgent - X and Y Axis Auto Scale for Chart
 
That works for my Y axis but I also need my X axis to auto scale also.
--
Sandi Gardner


"David Biddulph" wrote:

"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




David Biddulph

Urgent - X and Y Axis Auto Scale for Chart
 
"Sandi" wrote in message
...

"David Biddulph" wrote:

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


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




All times are GMT +1. The time now is 10:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com