Excel means the width of the gap between two of those blue bars. In the Series list, use the up and down arrows to reorder the series. Click on ‘Insert Line or Area Chart’ and insert the ‘Line with markers’ chart. stacked area chart), you can move the categories closer together by narrowing the graph. For example, a visual could be configured to select 100 categories and 10 series with a total of 1000 points. Highlight all the cells in columns Region, Revenue, and Remainder by holding down the Ctrl key (A1:A5 and C1:D5). So far, we introduced you to our new cast of modern chart types and placed the spotlight on Waterfall charts-the classic financial powerhouse chart. Use REPT Function to create an In-Cell Tornado Chart in Excel I love to do things in a different way or try new un-conventional ways to do old things. Extra settings to change the color and X, Y-axis names, etc. Bar chart with data points overlap excel Excel chart, Bar chart, Overlapping Bar chart.