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...
by Nate Moore | Jun 8, 2015 | Charts, Excel 2013
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...
