Excel Chart Videos & Online Courses

Basic Excel Chart Skills
Intermediate Excel Chart Skills
Advanced Excel Chart Skills
Training Workshops
Excel Chart Articles
Videos & Online Courses

Excel Chart Videos & Online Courses

  • Add/Insert an Excel chart/graph on a PowerPoint slide

    If you are using an Excel chart in a presentation, you will want to insert or add the chart to one of your PowerPoint slides. There are a number of ways you can do this. I recommend four methods, two where the graph in PowerPoint is not linked to the Excel worksheet and two where… Continue reading Add/Insert an Excel chart/graph on a PowerPoint slide

    Continue reading

  • “Torn paper” look for non-zero axis; Issue #436 April 2 2019

    In my Twitter feed I saw a number of well respected data visualization experts liking a recent article by RJ Andrews for the Data Visualization Society. In it he talks about the issue of starting the axis of a graph at a value other than zero. This is a common topic in the dataviz world…

    Continue reading

  • Matching Excel charts to a PowerPoint color scheme; Issue #434 March 5 2019

    If you create a graph in Excel, how do you get the colors to match the organization’s PowerPoint template? The two most common approaches are: 1) spend time typing in the RGB values for the correct colors into Excel for every graph, or 2) ignore the desire to make the colors match because of the…

    Continue reading

  • Comparing only one value to a standard; Issue #432 February 5 2019

    When you want to compare values to a standard, such as comparing output in various production plants to the goal, a dashed line on a column graph is a good visual to use. The dashed line runs across the graph and it is easy to see if each column is above or below the goal.…

    Continue reading

  • Bar charts with long category labels; Issue #428 November 27 2018

    How do we create graphs with category labels that contain a lot of text? If you are comparing values to each other, a column graph can get tricky since Excel and PowerPoint will turn the text at an angle and cut off labels that are really long. This makes it very hard for the audience…

    Continue reading