Menu
These chart types include: Treemap. A treemap chart displays hierarchically structured data. Box and Whisker. Excel 2016: Pivot Tables in Depth By: course • 3h 42m 27s • 101,331 viewers. Course Transcript - [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.
Course Info
- Duration:4h 36m 20s
- Skill Level:Intermediate
- Released:February 16, 2016
- Viewers:46,467
Learn the most in-demand business, tech and creative skills from industry experts.
Course details
Charts allow you to communicate information visually, in a way that's more impactful than raw data, and they happen to be one of the most powerful and easy-to-use features in Microsoft Excel. In Excel 2016, there are six brand-new chart types to learn. Let Dennis Taylor show you how to create different kinds of Excel charts, from column, bar, and line charts to exploded pies, and decide which type works best for your data. Learn how to fine-tune your chart's color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources. Plus, get an overview of the new chart types in Excel 2016: Treemap, Sunburst, Waterfall, Histogram, Pareto, and Box & Whisker.
The training wraps up with lesson on changing data sources for charts and printing and sharing charts.Skills covered in this course
Related courses
Course Transcript
- [Voiceover] Hi, I'm Dennis Taylor, and welcome to Excel 2016: Charts in Depth. Creating charts is one of Excel's most powerful and valuable features. And yet many users don't know how easy it is to create compelling and vibrant charts. In this course, we'll be looking at the concepts underlying charts and the tools to implement those concepts. I'll show you how to create standard and useful charts quickly and then how to fine tune those charts with a variety of techniques. You'll learn how to add greater impact to your charts with pictures and shapes, and then how to effectively use titles, labels, legends, axes, and gridlines. We'll look at analytical tools that will help you make sense of chart data and show you how to create dynamic charts that reflect fast-changing business environments. And I'll give you a ton of shortcuts and tips that will make your use of this popular tool more efficient and productive. So join me in Excel 2016: Charts in Depth.Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.Download the exercise files for this course. Get started with a free trial today.Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.Download on the App StoreGet it on Google PlayWatch this course anytime, anywhere. Get started with a free trial today.
Course Contents
- [Instructor] If you'd like to depict the datain columns A and B by way of a chart,you certainly could go to the Insert taband 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 showthe data in an accurate way.Here's some negatives, we see thosebeing depicted in the chart.If it is a column chart, you might want to considermaking the columns wider, an easy change there.Double-click any column.That activates the Format Data Series dialog boxon the right, and if these three columnsare 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 taband use one of the orientation buttons,possibly choose Rotate Text Up.That's not necessarily better but I think perhapsit's a bit more readable.Anyway, this is certainly one optionfor displaying the data.There is a new chart type however, introduced in Excel 2016that might depict this data in a more beneficial wayand bring out the idea that we've got some negativesin a way that focuses on the idea of cumulative data.
Now, I've got formulas in Column D here that showthe cumulative effect and these are in pure numbers.Column B is formatted so that we're seeing the numbersin thousands, nevertheless, in other wordsas we click on each of thesewe see the total so far year to date.So if I were to highlight these four numbers, for example,if you look in the status bar at the bottom of the screenyou'll see off to the right some 83.4.That more or less reflects the numberthat we're seeing right here,83.4 thousand in a rounded way.
So we don't necessarily need to have this data here,but I went there for referencebecause this new kind of chart,which is called a waterfall chart,could fit our needs perfectly here.Let's highlight this data, and go to the Insert tab.Now if you know where to find this,you'll know it's on the Option here,kind of looks like a waterfall,maybe that's pushing it a bit.Here's a drop arrow.Insert Waterfall or Stock Chart.As we slide over the option, description is,use this chart to show cumulative effectof a series of positive and negative values.
Use it when you have data representing inflowsand outflows, such as financial data.So there's the description of it.Now if you didn't know about this new chart feature,or you're not made aware of it, you might happen to goto Recommended Charts, and explore some of the options hereand there, what do we see?Third choice here: Waterfall Chart,and there's that same kind of description here,and let's look at this much larger by simply clicking OK.I'll make this bigger and move it around a little bit,and now we do see more clearlywhat's happening month to month.
We know that there are four negative months,and we can certainly see that in the data,but the chart brings it out even more clearly.Here too, we could possibly make an adjustmentto make these columns widerbut I don't think that's necessary here.However, the labels at the bottom might look a little funny.Let's close that dialog box, make these wider.Watch those labels across the bottom.They change this way.Now if we make them narrower, we could do this.Now unlike in the previous chart,where we could select the label areaand go to the Home tab, we can't do thison a waterfall chart, nor can we tie our titleto a given cell, so there are some limitationson some of the newer chart capabilitieswhen it comes to traditional labelingthat we might have done with other kinds of charts.
Nevertheless, the focus here is on the idea that,when the numbers are fluctuating,particularly if there are negatives here,we see the ebb and flow of the data.Think of each rectangle as representing the datathat we see in column B, so there's a minus 15 for April,this is a relative size 15, but it's a different color,and we see where the legend is Decrease.Now, what might look a little surprising here is,we've got three items in the legend.The blues represent the positive values,and we can see how those are being displayed on the chart.
The orange color represents decrease, we see those,and then we see gray for total, but where's the gray?Well there's a gray right there.So as I'm pointing right here to the gray,it's really not giving me any information here,but as I look at the scaling off to the left,I see that's about 85 or so.How does that correspond with our cumulative total?Remember, it wasn't necessary to have this here,but it's the number right here.Or is it the number right here?So we can see on either side of May here,we've got one number that's more or less a low 80,and one just to the right of it,just a little bit bigger.
So we're talking about equivalent relationshipof these two values, so, that's a little weak on the screenand there's no direct way to make that stronger.You could take out the grid lines.When you select a chart there's an option off to the right.Click the plus, you can remove the grid linesand then see those gray bars a little bit more clearly,but I think the focus really is on the overall visual here.I do think that's a little bit weak, that total entry there.Nevertheless, we see what the data is.I think it's helpful to also do this with the dataalthough it's not a requirement.
We see the data in a different waythan we might typically with other kinds of charts.You could, by way of different formulas,construct a chart somewhat like this using formulasand standard column chart, but you need to be usingsome manipulative techniques to hide parts of columns.You'd have to use something like a stacked columnand then hide the portions you didn't want to see.This is much more direct and easy to work with,and even though you don't have controlover all the display aspects of this chart,as you might in other charts,I think it gives you a good clear image.
Do experiment with the column width.I don't think it's necessary to change it here,but I'll double click one of the columnsand off to the right, the gap width is currently 50.What if I make that be 10?See what's happening there, brings them closer together.It does hide that slight gray linethat we can barely see here, reflecting total,but since that's barely readable anyway,you could make a case for saying,this is the appearance you want.And as always with a chart,do consider some of the chart styles.The example here, even though there's a drop arrow,there are only the styles that we see visible at the top,so as we slide across these,one or another of them might catch your fancyas being a better way to display this data.
But there's no question that it's a valuable additionto the arsenal of charts that we've got available.These were introduced in Excel 2016.You will not see this kind of a chart in 2013or any earlier versions of Excel.