A look at new chart types in Excel 2016: Waterfall

- [Instructor] If you'd like to depict the data…in columns A and B by way of a chart,…you certainly could go to the Insert tab…and possibly consider a column chart.…Here's an option, try that.…And we see that there are positives and negatives,…and there's no question that this does show…the data in an accurate way.…Here's some negatives, we see those…being depicted in the chart.…If it is a column chart, you might want to consider…making the columns wider, an easy change there.…Double-click any column.…That activates the Format Data Series dialog box…on the right, and if these three columns…are not already selected, they are here,…you will see a choice called Gap Width.…

Make that narrower.…This might make for a more interesting chart.…I'll change this down to 25.…I think this is a little bit easier to read,…but do notice that the labels here do overlap.…Possibly we could change these.…If you click on the label area here below the chart,…we can then go to the Home tab…and use one of the orientation buttons,…possibly choose Rotate Text Up.…