Search code examples
exceloffice365bar-chartpowerpoint

How to make a bar chart with 2-level header in powerpoint?

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

I actually created this sample chart in excel.

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

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?enter image description here

Solution

  • 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. enter image description here