by Nate Moore | Aug 24, 2015 | Business Intelligence
Welcome to a new series of Excel Videos introducing Excel 2013 BI tools. Today I’ll demonstrate two of the new Excel 2013 Business Intelligence tools, Power View and Power Map. We’ll cover how to build these visualizations and maps in future Excel Videos. Today I just...
by Nate Moore | Aug 3, 2015 | Charts, Excel 2013
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...
by Nate Moore | Jul 27, 2015 | Charts, Excel 2013
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...
by Nate Moore | Jul 20, 2015 | Charts, Excel 2013
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,...
by Nate Moore | Jul 13, 2015 | Charts, Excel 2013
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...