Basic Excel Chart Skills

  • 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 Get started creating a chart in Excel

  • 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 3 Steps you can take to spend less time updating Excel charts each month (Hint: use a strategic approach to your Excel chart worksheet)

  • 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

  • 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 Matching Excel charts to a PowerPoint color scheme; Issue #434 March 5 2019

  • Graph using Excel Data Bars; Issue #420 August 7, 2018

    Most business professionals are familiar with creating graphs in Excel using the powerful built-in graph features. Today I want to show another feature of Excel that can be used to create a bar graph quickly in Excel. It has limitations but can be particularly useful when you want to create multiple bar graphs of related… Continue reading Graph using Excel Data Bars; Issue #420 August 7, 2018