Intermediate Excel Chart Skills

Intermediate Excel Chart Skills

  • Scaling values for related data series; Issue #458 February 18 2020

    It is not uncommon that to communicate a message you need to show two or three related data series. It is relatively easy to create a single graph that has all the data series shown. The challenge comes when you have values in the data series that are different by an order of magnitude or… Continue reading Scaling values for related data series; Issue #458 February 18 2020

    Continue reading

  • 25 Advanced Excel Chart Tips and Tricks (video)

    These 25 tips and tricks will help you take your skills in creating Excel charts/graphs to the next level. The techniques apply to all modern versions of Excel (Excel 2013, 2016, 2019, and Excel 365 that is part of Office 365). These tips don’t require VBA, plug-ins, or add-ins so you can apply them right…

    Continue reading

  • How one character in a file name can mess up linking Excel cells or graphs to a PowerPoint slide

    I recently had someone contact me asking why the linking between Excel and PowerPoint was not working properly. They had followed my advice in this article & video but it wasn’t working properly. Let me explain the scenario, what I discovered the problem was, and the solution that shows how changing one character in the…

    Continue reading

  • Lining up related column graphs at the horizontal axis

    The challenge If you have related column graphs, how do you line them up so the horizontal axis in each graph is aligned? If you’ve ever tried to position the graphs manually in Excel or PowerPoint, you know that it is impossible to do it by trying to drag the graphs into the right position.…

    Continue reading

  • Adding a watermark to an Excel or PowerPoint chart/graph

    What can you do if you want to share a chart via email, Slack, or Teams but the chart doesn’t have all of the final data yet or you want others to know it contains confidential data? A good solution is to place a watermark behind the chart so everyone knows it is a draft…

    Continue reading