Intermediate Excel Chart Skills
Featured Articles
All Articles
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...
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...
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...
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...
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...