Intermediate Excel Chart Skills
-
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…
-
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 to solving this issue is to add…
-
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 with series name labels on the end of each line (part…
-
Marking the current date on a line chart in Excel
In this video I show how to add a current date line that will always show the current date on a line graph.
-
Marking the breakeven date on a line chart in Excel
In this video I show how to add a breakeven line to a line graph to show when the values change from negative to positive. You can adapt the technique in this video to other situations of values passing a criteria over time.