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:

	Null	A-B	C-E
	2016	2017	2016	2017	2016	2017
Overall	2.0	2.3	2.0	2.3	1.6	1.8
Personal	2.3	2.6	2.1	2.4	1.9	2.2
KSMBs	2.4	2.6	2.5	2.7	1.5	1.6
Networks	2.0	2.2	2.0	2.2	2.1	1.6
Community	1.3	1.5	1.3	1.6	0.8	1.3

<tbody>
</tbody>

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:

	Personal	Networks	KSMBs	Community
	Financial concerns (loans, pay, etc.)	I don't have time	Family impact/responsibilities	Conflict with current employment	I don't currently live in the community where I'd like to build my life	I don't have the right network	I don't know where to start	I don't have the right skills/experience	I don't see people like myself in these roles	I don’t feel representative of my community (identity, ideologically, or otherwise)
2016	2.6	2.2	1.7	1.9	1.6	2.4	2.7	2.1	1.3	1.3
2017	2.9	2.5	2.0	2.4	1.8	2.6	2.8	2.4	1.4	1.7

<colgroup><col span="5"><col><col span="5"></colgroup><tbody>
</tbody>

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.