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