How to Change the X-Axis Range in Excel Charts. For a business owner, Microsoft Excel 2010 provides an excellent platform for storing numerical information about your business.