Basic Excel Chart Skills

  • How to choose the right chart in Excel

    How do you choose the right chart to report results or analysis? Don’t select a chart or graph just because it looks cool or pretty. In this video I share the two big issues with putting spreadsheets on slides, the three reasons business professionals put spreadsheets on slides, and introduce a structured way to identify… Continue reading How to choose the right chart in Excel

    Continue reading

  • Get started creating a chart in Excel

    Never created a chart in Excel and want to learn the basics? Start with this article and video (also below) by Excel MVP Leila Gharani. Have an Excel chart you or someone else created and you want to copy it so you can use the same formatting with different data? Here’s how to do that from Excel MVP Jon…

    Continue reading

  • 3 Steps you can take to spend less time updating Excel charts each month (Hint: use a strategic approach to your Excel chart worksheet)

    With organizations measuring more metrics than ever before, the time it takes to update all the charts you create for senior managers seems to increase each month. You’ve streamlined the analysis using tools in Excel like Power Query, Pivot tables, and various formulas. Once you’ve identified the insights you need to communicate, it takes a…

    Continue reading

  • Online Excel support

    I don’t offer technical support so if you have a question about Excel charting or Excel in general, here are the online forums you can use to seek an answer or ask a question. Microsoft TechCommunity MrExcel forums ExcelGuru.com forums Microsoft Answers forum

    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