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 by a video.

The second section would show you how to do some cool stuff with Excel charts. These consist 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 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.

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.