Excel Chart Videos & Online Courses

Excel Chart Videos & Online Courses

  • Sort values and separate above/below target; Automatically updates; Excel Chart Tutorial

    If you have to report performance against a target or goal, this video will show you a good way to create a data visual chart that orders the results and separates those below the target and those above the target. The chart and all the text automatically update when the data changes next month, saving……

    Continue reading

  • Create a graph in PowerPoint using data and formulas from Excel for increased functionality

    Using the default copy and paste for an Excel graph into PowerPoint results in a link back to the Excel file. If that file is on a drive you can’t access, you can’t edit the graph. If you use the Embed workbook option when pasting the graph into PowerPoint you make the PowerPoint file large,……

    Continue reading

  • Cool effect for presenting Excel column charts/graphs in PowerPoint | Morph alternative hack

    Morph, the great PowerPoint feature that you can use with images, shapes, and text to create effects that look like a professional video is not available for charts. Charts are much more complex and Morph isn’t able to figure out where all the different elements should move. This video will show you a cool effect……

    Continue reading

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