Join Dennis Taylor for an in-depth discussion in this video A look at new chart types in Excel 2016: Waterfall, part of Excel Tips Weekly.
- [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.…
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.