Advanced Excel Chart Skills

  • Excel Chart Hacks from Excel Virtually Global 2023 conference session

    Recently I presented a session at the Excel Virtually Global conference on five of my favorite Excel chart hacks. I separated the content into five videos, one for each hack. In each video below, I share the hack as I presented it during the conference session, then I share some additional tips or resources to……

    Continue reading

  • Excel Dataviz Tutorial: Show Max, Min, & Scores for multiple criteria

    I created this visual based on a request from a student in the Master of Finance program at Queens University. They asked how to visually show the scores on multiple criteria for the organizations they were analyzing. I created a bar chart for each criteria that shows the score, how far it was from the……

    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

  • How to use a single Excel stacked bar chart for multiple diverging bar charts to report variance (planning a complex chart in Excel)

    One of the visuals I show in my FinancialViz courses is a multiple diverging bar chart that can show variance between actual and budget and actual and last year. This can also be used for actual and relative variances as well. I create it using a stacked bar chart and scatter with straight lines charts.……

    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