Excel Chart Display

[chrono2483]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Team
[/TD]
[TD]Below
[/TD]
[TD]Meeting
[/TD]
[TD]Above
[/TD]
[TD]Stretch
[/TD]
[TD]Target
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Homer
[/TD]
[TD]0%
[/TD]
[TD]19%
[/TD]
[TD]67%
[/TD]
[TD]14%
[/TD]
[TD]50%
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Marge
[/TD]
[TD]6%
[/TD]
[TD]34%
[/TD]
[TD]50%
[/TD]
[TD]5%
[/TD]
[TD]50%
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]Bart
[/TD]
[TD]4%
[/TD]
[TD]41%
[/TD]
[TD]48%
[/TD]
[TD]19%
[/TD]
[TD]50%
[/TD]
[/TR]
</tbody>[/TABLE]



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.

 

[thisoldman]

I hope this is clearly written and that it helps.

Arrange the data like this:

Excel 2012
	A	B	C	D	E	F
1		Below	Meeting	Above	Stretch	Target
2	Homer	0%
3	Homer		19%			50%
4	Homer			67%	14%
5
6	Marge	6%
7	Marge		34%			50%
8	Marge			50%	5%
9
10	Bart	4%
11	Bart		41%			50%
12	Bart			48%	19%
Sheet1

Select the cells A1:F12.
Using the menu bar, insert a stacked column chart.

Select the Target series.
From the right-click menu, select "Change series chart type..."
Change the Target series to a line chart. Do not move it to the secondary axis.

The Target series may disappear from the chart. From the chart right-click menu, choose "Select data..."
Click the button in the lower left-hand corner labeled "Hidden and Empty Cells". Select "Connect data points with line" and then OK out of the dialog boxes. The Target series line should appear.

Clear the contents of cells A2 and A4, A6 and A8, A10 and A12. This should fix the horizontal axis labels.

Do any other formatting you want: change the series gap width to 60%?