by Nate Moore | Jul 6, 2015 | Charts, Excel 2013
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...
by Nate Moore | Jun 29, 2015 | Charts, Excel 2013
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...
by Nate Moore | Jun 20, 2015 | Charts, Excel 2013
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...
by Nate Moore | Jun 13, 2015 | Charts, Excel 2013
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...
by Nate Moore | Jun 11, 2015 | Functions
I just added a new Excel Mastery page covering VLOOKUP to my website. The VLOOKUP article has been my most popular article and comes with a sample spreadsheet to follow along with the article and practice. You’ll also find a set of VLOOKUP videos to watch. If...