There a couple of ways to change chart plot order, the order that Excel plots data in a chart. I’ll show you two examples in Excel Video 471. As we’ve discussed in previous Excel Videos, having your chart data in a Table makes life easier. It’s easy to sort data in a...

Excel Video 470 is an easy video with three ways to delete data from a chart. Before we get to the three tips, please note that Excel 2013 makes it so easy to filter data from a chart that I only delete chart data that I never ever plan to chart again. Another tip is...

I have a tip in Excel Video 469 that I hope will save you some trouble when you’re creating charts with years. Watch how I chart the same set of data with one slight difference that makes a huge impact on how Excel sees years. If we set the chart data up correctly,...

The trick in Excel Video 468 is to use Tables as a chart data source. If you haven’t seen Tables in Excel, there’s a section with several playlists about Tables on my website that’s absolutely worth watching. Tables are a great way to organize detailed data. Watch how...

Excel Video 467 reviews the Hidden and Empty Cells button in the Excel 2013 Select Data Source window. You’ll see three options for dealing with missing data or empty cells in your source data. There’s not one right answer here. Depending on the data you’re charting...

Excel Video 466 shows two ways to add noncontiguous chart data to an Excel chart. Noncontiguous chart data is simply data that’s not next to the rest of the data you’re using as source data for a chart. Usually when I chart data I put all of the data to be charted in...

Excel Video 465 describes a couple of easy ways in Excel 2013 to add data to a chart. We’ll start with a couple thoughts on setting your data up for a chart to make it easy to maintain the chart long term. I’ll also demonstrate a way to drag the chart data range to...

Excel 2013 combo charts combine two different types of charts into the same chart. Excel Video 464 shows you how easy it is to build combo charts. Combo charts are great when you want to save space or focus attention by showing two pieces of information with a...

Excel Video 463 describes surface charts, radar charts, area charts, and scatter charts. I rarely use any of these charts. I’ve struggled to find an application in a medical practice for any of those charts that’s not easier to understand and more cleanly expressed in...

Excel 2013 Pie Charts are very common, but have three weaknesses we’ll explore and work around in Excel Video 462. The first challenge with a pie chart is that it takes up a lot of space relative to the amount of data the chart conveys. The second challenge is that...

Excel 2013 line charts are a great way to show and compare trends. As I go through a couple of line chart examples in Excel Video 461, watch for shortcuts to quickly switch the rows and legends of a chart with one click using the Switch Row/Column button. You’ll see a...

Excel 2013 Bar Charts in some ways are very similar to Excel 2013 Column Charts. In Excel Video 460 we’ll build a quick bar chart and then look at several sets of data displayed in both column and bar charts to see which types of data might look better in either...

There are several Excel 2013 Column Charts to choose from, and in Excel Video 459 we’ll walk through the differences and make a recommendation or two.  The first column chart recommendation from my perspective is to stick with two dimensional charts.  Save the 3D for...

Filtering chart data like we’ll do in Excel Video 458 is significantly easier in Excel 2013 than it was in the past.  Watch how hard it used to be to filter chart data (if you really want to know how hard it was, watch Excel Videos 95 and 96) and how easy it is to...

Add a little more style and little more color to your chart with Excel Video 457.  Watch for three things in this Excel Video. First, once you have a chart style selected, the Quick Layout button will show you how your chart might look with Data Labels, Data Tables,...

Your friendly Business Intelligence guy is not the best source for learning about style, but he can tell you about Chart Styles in Excel Video 456. Once you’ve built a chart, here’s how to use the new Excel 2013 Chart Styles button to add a bunch of different style...

You can also use Trendlines to forecast on a chart, and Excel Video 455 shows you how to do it. First, please be aware that I don’t use Trendlines to forecast, and I’ll point you to Excel Videos 101-103 for other ways to forecast in Excel. That said, you can add a...