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...
