Excel Chart Videos & Online Courses

Excel Chart Videos & Online Courses

  • Excel Chart Tip: Add a goal or target line to a bar chart

    When you are showing ranked data in a bar chart you may want to add a goal or target line to easily identify those with performance above the goal and those below the goal. Instead of drawing the line on top of the chart, build the target or goal line as part of the chart… Continue reading Excel Chart Tip: Add a goal or target line to a bar chart

    Continue reading

  • Excel Chart Tip: Add a CAGR line callout to a column chart

    When you are reporting sales, shipments, clients served, or any measure where you want to show the growth rate over the period of time along with the values in each period, a column chart with a CAGR line callout can be a good visual to use. Instead of drawing the line on the chart and…

    Continue reading

  • 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

  • 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

  • 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