Join David Rivers for an in-depth discussion in this video Exploring new graphs and charts, part of Office 2016 New Features.
- [Instructor] Office 2016 now includes a set of new charts…to give you more ways to explore data here in Excel,…but also in Word and PowerPoint.…To explore these new charts, we're going to work…in Excel, the most popular program…in the suite for working with charts.…We left off here looking at our procurement by region,…which does include a couple of charts…that we're already familiar with; the pie chart,…you can see the bar graph here using columns.…And we're going to continue with this file lhproducrement.xlxs.…
Down at the bottom we'll click the Gross Revenue tab though…to switch over to some data we see over here…in the top left corner, and we're going to use that data…to create one of the new charts available here in Excel.…So let's select it first, click and drag…from cell A1 across and down to B13.…That's the first step; now we're ready…to insert the chart from the insert tab.…You'll notice when you click it there is a charts group,…still contains recommended charts and a number…of shortcuts to some of the more popular ones.…
Skill Level Intermediate
Q: This course was updated on 05/22/2017. What changed?
A: The following topic was updated: exploring new graphs and charts.
Q: This course was updated on 10/20/2017. What changed?
A: The course now includes coverage of the new charts in Excel: TreeMap, Sunburst, and Waterfall.