by Nate Moore | Aug 10, 2020 | Appointments, Charts, Pivot Tables, Podcasts
Podcast: Play in new window | DownloadSubscribe: Android | RSS This BIG Idea is a project I did last week for a group in the West. We summarized all of their E&M codes for the past couple of years by month and provider and then used Excel tools like Slicers and...
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...
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...
