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 Plot Two Things on the Same Y Axis in Excel. Properly formatted charts and graphs can help you grasp the patterns and trends hidden within the raw data of an Excel spreadsheet.

If you have uneven distribution of data in your Excel chart, here is a better way to change the automatic axis settings.

Excel 2016's many new features include six new chart types. Here we cover Histogram, Pareto, and Waterfall, which cover statistical, trend, and other relationships.

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.