I want to create a bar chart in Powerpoint with two level header, the exact result is as below:

I actually created this chart in excel.

Now I am going to duplicate it in Powerpoint. However the most I can do is one level header as below:

When I enter the "edit data" session, it seems extending the select grid (purple grid) to include the year level is impossible. Would anyone please help me?

CodePudding user response：

Select the "Select Data" dialog not the "Edit Data" dialog. Then, select, "Edit" for the "Horizontal (Category) Axis Labels" Then, re-select the axis to include both columns A and B. Then select OK.
Boom, your chart works.