Excel Charts vs PivotCharts | Comparison | Which is Best?

Posted on:  04/08/2022 Excel Charts vs PivotCharts | Comparison | Which is Best?

Which is best in Excel? Classic CHARTS or PIVOTCHARTS? I will show you both ways of creating charts in Excel. I demonstrate step by step what's involved in each method, which one is the most flexible and powerful, and which one I prefer.

Charts vs. PivotCharts

Charts vs. PivotCharts

We take a look at creating some classic charts (in Excel, the shortcut is ALT + F1) using a date-based cell range, and I show you how to customize the appearance to skip dates without data.


The second method, using PivotCharts, is also demonstrated in this tutorial. We look at how easy it is to create a PivotTable and then a PivotChart from it and obtain a powerful and flexible chart with a few clicks.

YouTube Video

Other Excel articles

Video Chapters / Bookmarks

  • 00:00 Introduction
  • 00:17 Creating a classic chart
  • 02:10 Creating a PivotChart
  • 03:15 Closing remarks

Keyboard shortcuts to create a chart

  • F11 - Create a chart on a separate worksheet
  • ATL + F1 - create a chart on the current worksheet

Recent Excel Articles

Excel Training for the University of Georgia's Online and Professional MBA Students

Excel Training for the University of Georgia's Online and Professional MBA Students

Copilot in Excel - Ask Copilot Questions about Keyboard Shortcuts, Functions, and Steps

Copilot in Excel - Ask Copilot Questions about Keyboard Shortcuts, Functions, and Steps

Mastering Excel Slicers: A Comprehensive Guide

Mastering Excel Slicers: A Comprehensive Guide

Mastering Loan Amortization: A Comprehensive Guide to Understanding and Comparing Loans

Mastering Loan Amortization: A Comprehensive Guide to Understanding and Comparing Loans

Recent Teams Articles

Microsoft Teams - Save Chat and Channel Messages is Back!

Microsoft Teams - Save Chat and Channel Messages is Back!

Master Microsoft Teams Follow Threads to Boost Your Productivity

Master Microsoft Teams Follow Threads to Boost Your Productivity

Recent Word Articles

Microsoft Copilot for Word: How to Reference a Folder

Microsoft Copilot for Word: How to Reference a Folder

Copilot in Word: Quickly Add Numbers with Ease

Copilot in Word: Quickly Add Numbers with Ease

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and Microsoft Most Valuable Professional (MVP). Chris works as a Senior Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel featuring over 900 technology videos that cover various apps, including Excel, Word, PowerPoint, Zoom, Teams, Coilot, and Outlook. To date, the channel has had over 25 million views. Menard also participates in 2 to 3 public speaking events annually, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories