Create Stacked bar with multiple critera and a second axis that is a line

[baindes]

I am looking to create a stacked bar chart with side by side bars being June then July for the first series "locate information" then the second set of bars side by side are "search" and so on. With the stacked data being Negative, Neutral, Positive and then...... SENTIMENT would be on a secondary axis on the right hand side of the chart as a line.

Above is how I have my data set up but that causes a break between the data when you chart it but the line breaks as well. If you chart that data you can see what I am attempting to do.

Thank you for any help you can offer, it is very much appreciated.

Kind regards,
Baindes

Excel 2010
	N	O	P	Q	R
4		Negative	Neutral	Positive	Sentiment Score
5	July Locate Information	29	24	7	-0.67
6	June Locate Information	27	20	6	-0.56
7
8	July Search	24	25	2	-0.66
9	June Search	22	26	5	-0.47
10
11	July Download SW/Firmware	12	35	1	-0.37
12	June Download SW/Firmware	11	32	0	-0.4
13
14	July Content	15	17	3	-0.44
15	June Content	14	19	2	-0.47
SWTG Stacked Sentiments (2)

 

[oldbrewer]

look on jon peltier website....

 

[baindes]

Hi and thank you for the direction. I looked but don't see a chart with the criteria I am looking for. I have spent a few days looking and I see the same things. I am not sure if it can be done. Thanks again!

Baindes

 

[oldbrewer]

task	Negative	Neutral	Positive
June Locate Information	27	20	6
June Search	22	26	5
July Locate Information	29	24	7
July Search	24	25	2 this charts ok as side by side groups of 3 bars for each of the four tasks

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>