two-level header groupings in x-axis

[akswartz85]

Does anyone know how to force Excel to group data together by headers in the X Axis?

It did it automatically with this first graph (barriers by ladder group) after I merged some headers together over a secondary set of headers.

Table format of first graph:
[TABLE="class: grid, width: 680"]
<tbody>[TR]
[TD][/TD]
[TD="colspan: 2"]Null[/TD]
[TD="colspan: 2"]A-B[/TD]
[TD="colspan: 2"]C-E[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2016[/TD]
[TD]2017[/TD]
[TD]2016[/TD]
[TD]2017[/TD]
[TD]2016[/TD]
[TD]2017[/TD]
[/TR]
[TR]
[TD]Overall[/TD]
[TD="align: right"]2.0[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]2.0[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]1.6[/TD]
[TD="align: right"]1.8[/TD]
[/TR]
[TR]
[TD]Personal[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]2.6[/TD]
[TD="align: right"]2.1[/TD]
[TD="align: right"]2.4[/TD]
[TD="align: right"]1.9[/TD]
[TD="align: right"]2.2[/TD]
[/TR]
[TR]
[TD]KSMBs[/TD]
[TD="align: right"]2.4[/TD]
[TD="align: right"]2.6[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]2.7[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: right"]1.6[/TD]
[/TR]
[TR]
[TD]Networks[/TD]
[TD="align: right"]2.0[/TD]
[TD="align: right"]2.2[/TD]
[TD="align: right"]2.0[/TD]
[TD="align: right"]2.2[/TD]
[TD="align: right"]2.1[/TD]
[TD="align: right"]1.6[/TD]
[/TR]
[TR]
[TD]Community[/TD]
[TD="align: right"]1.3[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: right"]1.3[/TD]
[TD="align: right"]1.6[/TD]
[TD="align: right"]0.8[/TD]
[TD="align: right"]1.3[/TD]
[/TR]
</tbody>[/TABLE]


First graph outcome (this is what I want:
https://drive.google.com/file/d/1_-2hj2gyjIuIlPOCnmkIEvvZNslJjzTb/view?usp=sharing (sorry for the link, but the image URL option wasn't working).

I formatted the second table in the same way, but the resulting chart doesn’t show the grouping.

2nd table formatting:

[TABLE="class: grid, width: 735"]
<colgroup><col span="5"><col><col span="5"></colgroup><tbody>[TR]
[TD][/TD]
[TD="colspan: 4"]Personal[/TD]
[TD="colspan: 2"]Networks[/TD]
[TD="colspan: 2"]KSMBs[/TD]
[TD="colspan: 2"]Community[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Financial concerns (loans, pay, etc.)[/TD]
[TD]I don't have time[/TD]
[TD]Family impact/responsibilities[/TD]
[TD]Conflict with current employment[/TD]
[TD]I don't currently live in the community where I'd like to build my life[/TD]
[TD]I don't have the right network[/TD]
[TD]I don't know where to start[/TD]
[TD]I don't have the right skills/experience[/TD]
[TD]I don't see people like myself in these roles[/TD]
[TD]I don’t feel representative of my community (identity, ideologically, or otherwise)[/TD]
[/TR]
[TR]
[TD="align: right"]2016[/TD]
[TD="align: right"]2.6[/TD]
[TD="align: right"]2.2[/TD]
[TD="align: right"]1.7[/TD]
[TD="align: right"]1.9[/TD]
[TD="align: right"]1.6[/TD]
[TD="align: right"]2.4[/TD]
[TD="align: right"]2.7[/TD]
[TD="align: right"]2.1[/TD]
[TD="align: right"]1.3[/TD]
[TD="align: right"]1.3[/TD]
[/TR]
[TR]
[TD="align: right"]2017[/TD]
[TD="align: right"]2.9[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]2.0[/TD]
[TD="align: right"]2.4[/TD]
[TD="align: right"]1.8[/TD]
[TD="align: right"]2.6[/TD]
[TD="align: right"]2.8[/TD]
[TD="align: right"]2.4[/TD]
[TD="align: right"]1.4[/TD]
[TD="align: right"]1.7[/TD]
[/TR]
</tbody>[/TABLE]

The graph that Excel generates:
https://drive.google.com/file/d/1yrTFu77mvNgTWvjT06elXIVDAps0V2fN/view?usp=sharing

thank you!

 

[pgc01]

Hi

It should work directly.
Are you sure you included the first row in the x axis?

Please check.