chrono2483
Board Regular
- Joined
- Aug 23, 2014
- Messages
- 164
- Office Version
- 2016
A | B | C | D | E | F | |
1 | Team | Below | Meeting | Above | Stretch | Target |
2 | Homer | 0% | 19% | 67% | 14% | 50% |
3 | Marge | 6% | 34% | 50% | 5% | 50% |
4 | Bart | 4% | 41% | 48% | 19% | 50% |
<tbody>
</tbody>
Hello,
I'm having a bit of difficulty with converting my data into a chart. I can add the table into a chart. The chart type is a combination of Clustered Column and Stacked Column and Line.
I want the the data displayed as follows:
Clustered Column: Below, Meeting
Stacked Column: Above, Stretch
Line: Target
Knowing I have to use both Primary and Secondary axis, I want the order of the data for each team displayed in the following order:
Below (individual bar) | Meeting (individual bar) | Above & Stretch (stacked bar) | Target (line)
HOWEVER, no matter the order i arrange the data in, it always displays as:
Below (individual bar) | Above & Stretch (stacked bar) | Meeting (individual bar) | Target (line)
Am I missing something, to achieve the order I desire?
Thank you.