Charts are great for showing comparisons and trends. In this tutorial, we will explain how to apply layouts and styles in a chart in Excel.

Click one of those colors, and Excel applies it to the legend instantly. This flexibility gives you the ability to see how different legend colors look in relation to existing chart elements.

Charts that contain more than one set of data should always display each set using a different color and include a chart legend in addition to axis names and labels.

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.