Intermediate Excel Chart Skills

Intermediate Excel Chart Skills

  • 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 How one character in a file name can mess up linking Excel cells or graphs to a PowerPoint slide

  • 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 Lining up related column graphs at the horizontal axis

  • 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 Adding a watermark to an Excel or PowerPoint chart/graph

  • Excel bar chart with conditional formatting based on MoM change %

    Conditional formatting of Excel charts allows you to have the formatting of the chart update automatically based on the data values. A common approach is to use the values as the criteria as shown in the article and video on creating a conditional formatting column chart. In this article and video I want to show… Continue reading Excel bar chart with conditional formatting based on MoM change %

  • Conditional formatting for Excel column charts

    Conditional formatting is a very popular feature of Excel and is usually used to shade cells with different colors based on criteria that the user defines. We can apply the idea of conditional formatting to column charts by using multiple data series because the Excel feature applies only to cells, not charts. Define boundary values… Continue reading Conditional formatting for Excel column charts