With a panel chart, you can show two or more similar sets of data, in a single chart. The groups are separated by lines, so they appear to be individual panels, within the Excel chart.

The dividing lines are created with error bars on a separate series, and this video shows you the steps.

Visit this page for written steps, and to get the Excel sample file.
[ Ссылка ]

Video Timeline:
0:00 Introduction
0:24 Step 1 - Insert Column
1:11 Step 2 - Create Pivot Table
2:16 Step 3 - Copy Data As Values
2:48 Step 4 - Create Line Chart
3:31 Step 5 - Add Dividing Lines
7:06 Step 6 - Final Formatting

свернуть