Intermediate Excel Chart Skills
Featured Articles
All Articles
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...
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...
Stagger long axis labels and make one label stand out in an Excel column chart
The problem with long axis labels and the common solution If you have long axis labels in a column chart, Excel will rotate them to fit the full labels in if the chart is not wide enough. This is hard for the viewer to read. The common approach...
Using the CONCAT function to create custom data labels for an Excel chart
You are familiar with data labels for Excel graphs, typically they are used for adding the values to columns or bars (part of my suggestions for making professional column or bar charts). Next level usage is to replace the legend in a line graph...