Intermediate Excel Chart Skills
-
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…
-
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…
-
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.…
-
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…