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...
by Nate Moore | May 23, 2015 | Charts, Excel 2013
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...
by Nate Moore | May 20, 2015 | Functions
I’ve posted another free article on my website. Today’s topic is Absolute vs Relative References in Excel. Spreadsheets are great at being able to create one formula and copy it hundreds or thousands of times. Many times that copy and paste is good...
by Nate Moore | May 18, 2015 | Charts, Excel 2013
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...