There are 17 different types of charts in Excel, so it can sometimes be difficult to choose which one to use. In this article ...

How Excel Charts Work A chart has an x-axis range and a y-axis range to show the correlation between two different data sets. The x-axis is the horizontal category line.

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.

You can insert a chart in Excel by selecting your dataset, heading over to the Insert tab, and clicking the chart type you want in the Charts group of the ribbon. Then, you can customize them by ...

ADJUST THE AXIS SCALE ON AN EXCEL CHART Excel usually does a good job second-guessing me when it chooses the scale for an axis on a chart. But sometimes, to better focus some data, I need to adjust ...

Learn how to ignore zero values in Excel charts with step-by-step tips to create clean, accurate, and professional visuals.

The total area under the curve is equal to 100% of respondents, but we are most interested in where respondents fall along the horizontal axis. In other static versions of this chart in the report, we ...

In this graph the intervals on the bottom axis are unequal, making it difficult to read. Scales should either start at zero, or be concertinaed (squashed) as shown in the y-axis in the above graph.

This technique lets you build an Excel chart that shares supportive information in series form.