Excel Chart Videos & Online Courses

Excel Chart Videos & Online Courses

  • Using superscript numbers to add footnotes to financial reports and graphs in Excel

    It is common to use footnotes when reporting financial results. Footnotes allow you to be transparent with the viewer and disclose important assumptions or clarifications so that they can more accurately interpret the results. By using superscript numbers, we can make adding footnotes to financial reports and charts in Excel easier. To create a superscript… Continue reading Using superscript numbers to add footnotes to financial reports and graphs in Excel

  • 25 Advanced Excel Chart Tips and Tricks (video)

    These 25 tips and tricks will help you take your skills in creating Excel charts/graphs to the next level. The techniques apply to all modern versions of Excel (Excel 2013, 2016, 2019, and Excel 365 that is part of Office 365). These tips don’t require VBA, plug-ins, or add-ins so you can apply them right… Continue reading 25 Advanced Excel Chart Tips and Tricks (video)

  • Conditional formatting for Excel column charts

    Conditional formatting is a very popular feature of Excel and is usually used to shade cells with different colors based on criteria that the user defines. We can apply the idea of conditional formatting to column charts by using multiple data series because the Excel feature applies only to cells, not charts. Define boundary values… Continue reading Conditional formatting for Excel column charts

  • Using the CONCAT function to create custom data labels for an Excel chart

    You are familiar with data labels for Excel graphs, typically they are used for adding the values to columns or bars (part of my suggestions for making professional column or bar charts). Next level usage is to replace the legend in a line graph with series name labels on the end of each line (part… Continue reading Using the CONCAT function to create custom data labels for an Excel chart

  • Marking the current date on a line chart in Excel

    In this video I show how to add a current date line that will always show the current date on a line graph.