Скачать или смотреть How to Make a Comparison Chart in Excel

In this tutorial, you’ll learn different ways to create comparison charts in Excel to analyze and compare data clearly. We’ll cover multiple chart types, including clustered columns, scatter charts, combo charts, and PivotTable-based visuals.

00:00 – Intro
00:20 – Compare Multiple Categories Side-by-Side with a Clustered Column Chart
01:31 – Plot a Scatter Chart
02:27 – Combine Visual Styles with a Custom Combo Chart
03:17 – Summarize and Compare with a Pivot Table and Line Chart

📥 Downloadable Resource: https://excelinsider.com/wp-content/u...

📝 Full tutorial here: https://excelinsider.com/excel-charts...

🛠️ Spreadsheet Services: https://excelinsider.com/spreadsheet-...
📊 Templates & Tools: https://excelinsider.com/template-ser...

📌 Subscribe to Excel Insider for weekly tips:    / @excelinsider32  

Connect With Us:
📧 Email: [email protected]

Transcript:
00:00 – Intro
Welcome! In this video, we’ll explore several methods to build comparison charts in Excel that make it easy to evaluate differences across categories or datasets.

00:20 – Compare Multiple Categories Side-by-Side with a Clustered Column Chart
We start by using a clustered column chart to compare multiple categories side by side. This is one of the most effective ways to visualize comparisons in Excel.

01:31 – Plot a Scatter Chart
Next, we create a scatter chart to compare relationships between two numerical variables and identify trends or outliers.

02:27 – Combine Visual Styles with a Custom Combo Chart
Here, we combine different chart types into a custom combo chart. This approach is ideal when comparing metrics with different scales.

03:17 – Summarize and Compare with a Pivot Table and Line Chart
Finally, we summarize the data using a PivotTable and visualize the comparison with a line chart for dynamic and interactive analysis.