akswartz85
New Member
- Joined
- Mar 31, 2010
- Messages
- 49
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:
<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:
<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!
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!