In the image above, Microsoft have added six new charts: Treemap, Sunburst, Histogram, Box and Whisker, Waterfall, and Funnel. The dialogue box looks slightly different in Excel 2013: To change the chart type, locate the Type panel on the Excel Ribbon bar (you need to have your chart selected to see it): Instead of having a 2D column chart, as above, you can have a 2D bar chart. You can change the type of chart, as well. In the image below, we've gone for Layout 10: In newer versions of Excel, you may have to click the Quick Layout option on the Chart Layouts panel:Īgain, click on each one in turn and see what happens to your chart. Locate the Chart Layout panel on the Design tab of the Excel Ribbon bar. You can also change the layout of your chart in the same way. Watch what happens to your chart when you select a style. Work your way through the Styles, and click on each one in turn. You'll then see a drop down sheet of new styles (Excel 2007):Īnd here's the Styles in Excel 2013 to 2016: To see more styles, click the arrows to the right of the Chart Styles panel: In newer versions of Excel, your Chart Styles will look like this:Ĭlick on any chart style, and your chart will change. The Styles will look like this in Excel 2007: If you can't see the Styles, click anywhere on your chart to select it, and you should see the Ribbon change. You can easily change the Style of your chart.

Histogram chart excel 2013