Select Page

Excel Video 454 Trendlines Part 1

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

Excel Video 453 Legends

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

Excel Video 452 Gridlines

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

Excel Video 451 Error Bars

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

Excel Video 450 Data Tables

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

Excel Video 449 Data Callouts

Excel Video 449 introduces Data Callouts, a new feature in Excel 2013. Watch how to use and customize Data Callouts. In my opinion, the space Data Callouts take up isn’t usually justified by the additional information they may provide. I typically use Data Labels as...