Line graph over the top of a Stacked area graph

[burkavic]

I made the below graph with the sloped colored lines indicating the properties of a powder.

I am trying to color the sections to provide a better visual. I tried using a combo charted with a stacked area and line graphs but i ended up with a graph like the below picture. I cannot seem to change the X axis values and i dont understand why the line looks how it does.

I am able to get this far but when i begin to add a line to the graph it completely messes the graph up. Is it possible to do what im trying?

 

[awoohaw]

please post the series and values, and indicate which series you want in the stacked area and which in the lines?

 

[burkavic]

This is what was used to give the shaded areas. (This information was all given to me to plot, the UFS value of 10 for Non flowing would not allow me to get the red section so i had to alter that to a random extremely high value.)

This is information to inform us where your material falls into. The Slope function for very cohesive is =SLOPE(J6:J7,I6:I7) where J is the red square and I is the blue and the formula is the same for the corresponding columns. The slope function for the material 1 is =SLOPE(D12:D17,C12:C17) where D is the red column in the final image and C is the blue. Flow function index is 1/the slope value. And for completion but not really relevant to the graph, the flow behaviour is worked out using the following, =IF(D47<1,"non flowing",IF(D47<2,"very cohesive",IF(D47<4,"cohesive",IF(D47<10,"easy flowing",IF(D47>=10,"free flowing")))))

and the below information is example data that we would need to plot over the shaded areas. If you need any more information please let me know.

 

[awoohaw]

which are the series? which are the values? Which are the X and Y axes?

Please use the xl2bb tool (link below) to link a mini workbook with the chart source series data.
Thanks,

 

[burkavic]

PFT charts template v2.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
3			Standard Flow Function Guide
4			Free Flowing		Easy Flowing		Cohesive		Very Cohesive		Non Flowing
5			MPCS	UFS	MPCS	UFS	MPCS	UFS	MPCS	UFS	MPCS	UFS
6			0	0	0	0	0	0	0	0	0	0
7			22	2.2	22	5.5	22	11	22	22	0	22
8
9			Sample Analysis Comparison
10			Material 1		Material 2		Material 3		Material 4
11			MPCS	UFS	MPCS	UFS	MPCS	UFS	MPCS	UFS
12			0.047	0.2	0.036		0.038		0.022
13			1.362	0.3	1.347		1.282		1.577
14			2.755	0.4	2.776		2.668		3.15
15			5.606	1	5.647		5.466		6.47
16			11.356	2	11.441		11.125		13.034
17			23.328	4	23.312		22.548		26.794
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41	Flow Function Index Calculation								Flow Function Index Bands
42			SLOPE	Flow function index		Flow Behaviour			<1	non flowing
43	Very Cohesive		1.00	1.00		very cohesive			1<ff<2	very cohesive
44	Cohesive		0.50	2.00		cohesive			2<ff<4	cohesive
45	Easy Flowing		0.25	4.00		easy flowing			4<ff<10	easy flowing
46	Free Flowing		0.10	10.00		free flowing			10<ff	free flowing
47	Material 1		0.17	5.95		easy flowing
48	Material 2		#DIV/0!	#DIV/0!		#DIV/0!
49	Material 3		#DIV/0!	#DIV/0!		#DIV/0!
50	Material 4		#DIV/0!	#DIV/0!		#DIV/0!
51
Sheet1

Cell Formulas
Range	Formula
C43	C43	=SLOPE(J6:J7,I6:I7)
D43:D50	D43	=1/C43
F43:F50	F43	=IF(D43<1,"non flowing",IF(D43<2,"very cohesive",IF(D43<4,"cohesive",IF(D43<10,"easy flowing",IF(D43>=10,"free flowing")))))
C44	C44	=SLOPE(H6:H7,G6:G7)
C45	C45	=SLOPE(F6:F7,E6:E7)
C46	C46	=SLOPE(D6:D7,C6:C7)
C47	C47	=SLOPE(D12:D17,C12:C17)
C48	C48	=SLOPE(F12:F17,E12:E17)
C49	C49	=SLOPE(H12:H17,G12:G17)
C50	C50	=SLOPE(J12:J17,I12:I17)

 

[burkavic]

X axis are any value as MPCS and y axis is any values as UFS, the values in sample analysis are the values that i wish to plot although there are only one full set of data there. My series are 42a - 50a