G Guest Jun 8, 2006 #1 How do I get my X axis and Y axis to auto scale inside my chart when I add new data in my spreadsheet?
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 Jun 8, 2006 #2 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.
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 Jun 9, 2006 #4 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.
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.
