Intermediate Excel Chart Skills
Featured Articles
All Articles
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
Do you want to create customized data labels for a chart that can contain whatever text, values, or dates you need? This video is for you. In this video I show how using the CONCAT function can allow you to create customized data labels for your...
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. https://youtu.be/5v2uuxQe_d0
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...
Add/Insert an Excel chart/graph on a PowerPoint slide
If you are using an Excel chart in a presentation, you will want to insert or add the chart to one of your PowerPoint slides. There are a number of ways you can do this. I recommend four methods, two where the graph in PowerPoint is not linked to...