Naming Basics Best practice recommendations are to create a chart placing independent variables on the horizontal, x-axis and dependent variables on the vertical, y-axis.

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.