by Nate Moore | Apr 13, 2015 | Charts, Excel 2013
You can also use Trendlines to forecast on a chart, and Excel Video 455 shows you how to do it. First, please be aware that I don’t use Trendlines to forecast, and I’ll point you to Excel Videos 101-103 for other ways to forecast in Excel. That said, you can add a...
by Nate Moore | Apr 6, 2015 | Charts, Excel 2013
Trendlines make it easier to see trends and patterns in your data. Excel Video 454 shows how to add a trendline to your chart. Trendlines are added a series at a time. Watch how to add a trendline, the types of trendlines to add, how to rename a trendline, and how to...
by Nate Moore | Mar 30, 2015 | Charts, Excel 2013
Chart Legends are pretty straightforward, but Excel Video 453 has a few tricks you may find helpful. There’s not much to Legends except where to put them, but watch for an easy way to change the chart legend and the x axis to better analyze your data. I’ll also give...
by Nate Moore | Mar 23, 2015 | Charts, Excel 2013
It’s easy to customize Gridlines in Excel Video 452. You can choose between horizontal and vertical and between major and minor gridlines, but that’s about it. Since Gridlines are so straight-forward, watch for another way to access and change the components of your...
by Nate Moore | Mar 16, 2015 | Charts, Excel 2013
Excel Video 451 shows you how to use Error Bars to display statistical information and a clever trick to show more information with fewer pixels. Error Bars are normally used to show uncertainty or confidence around numbers on a chart. For example, there are ways to...
by Nate Moore | Mar 9, 2015 | Charts, Excel 2013
Excel Video 450 shows you how easy it is to add a Data Table to a chart in Excel 2013. Watch how I remove the Legend from the chart and include it as part of the Data Table instead. You’ll see some new ways to customize the Data Table in Excel 2013 and I’ll show you...
