Intermediate Excel Chart Skills

Intermediate Excel Chart Skills

  • 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

  • Excel Chart Hack: Put data series labels in the bars of a bar chart instead of the legend

    In a previous video (https://youtu.be/jqA5BUbgAFM) I showed how to replace the legend in a column chart with labels added using a scatter chart. Someone asked if this could also be done for a bar chart. This video shows you how. It is a slightly different approach because the scatter plot has to be placed on……

    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

  • Use this hack to add the data series names in the columns of a graph instead of using a legend in Excel

    When you are using a clustered column graph in Excel that has two or more data series, how do you tell the viewer which set of columns is which data series? The default method is to use colors and the legend. This video shows you a way to add the data series names into one……

    Continue reading

  • Fixing the “Values don’t add to 100% because of rounding” issue in Excel pie charts & tables

    Too often I see a footnote on an Excel chart or table in a presentation that says “the values don’t add to 100% because of rounding.” Sometimes the values don’t add to 100% and there is no footnote, it just appears to be a mathematical mistake. Both of these situations cause doubt in the mind……

    Continue reading