Excel Charting Tips & Tutorials (Resource Guides + Videos)

Looking to learn some awesome things about Excel charting?

On this page, you'll find a collection of useful Excel charting tips and tutorials. 

This page is divided into two sections.

The first section will show you how to create different types of charts in Excel. These are in-depth step-by-step tutorials and are often accompanied with a video.

The second section would show you how to do some cool stuff with Excel charts. These consists of some advanced techniques that can include the use of VBA and/or formulas.

Excel Charting Tutorials

In this section, I have provided detailed guides on creating different types of charts in Excel.

Excel charts play a crucial role when you’re creating Excel dashboards or reports.  In this section, you will find different chart types that are well suited for Excel Dashboards.

For example, if you want to show comparison then you can use an Actual Vs. Target chart or a bullet chart. If you want to show a timeline, you can use the milestone chart.

While most of these charts are not available by default, you can easily create these using the steps shown in the tutorial.

I regularly update this section with new Excel charting tutorials.

Want to quickly learn the art and science of creating world-class dashboards, check out my Online Excel Dashboard Training.

Excel Charting Tips

While the earlier section is about creating some useful Excel charts, this section has useful charting tips to help you make more interactive, dynamic, and advanced charts.