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? In today's Excel video, I show you both ways of creating charts in Excel, show you step by step what's involved in each method and which one is the most flexible, 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 and we look at how easy it is to create a PivotTable and then a PivotChart from it, and with a few clicks, obtain a powerful and flexible chart.

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 Conditional Formatting with the TODAY function | Duplicate Rule

Excel Conditional Formatting with the TODAY function | Duplicate Rule

Excel Accounts Payable / Accounts Receivable Exercise - Watch Chris Work

Excel Accounts Payable / Accounts Receivable Exercise - Watch Chris Work

Excel Recommend PivotTables - Improved Experience

Excel Recommend PivotTables - Improved Experience

Excel PivotTable - Calculate the number of days of each week for every month of the year

Excel PivotTable - Calculate the number of days of each week for every month of the year

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with other 750 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 10 million viewers have appreciated.

Categories