Excel Combo Chart Help

[Airam]

Hello

I am trying to create a combo chart using clustered and Line chart. For Clustered I want to show the LOB SL% per month and the comparison of Actual Volume as the secondary axis.

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1			January	February	March	April	May
2		LOB 1 SL %	75%	80%	35%	40%	65%
3		LOB 2 SL %	50%	40%	30%	50%	80%
4		LOB 3 SL %	35%	55%	98%	74%	89%
5		LOB 1 Volume %	108%	85%	130%	150%	45%
6		LOB 2 Volume %	85%	55%	98%	42%	56%
7		LOB 3 Volume %	15%	50%	98%	74%	12%
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
Sheet1

 

[Airam]

Hello

I am trying to create a combo chart using clustered and Line chart. For Clustered I want to show the LOB SL% per month and the comparison of Actual Volume as the secondary axis.

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1			January	February	March	April	May
2		LOB 1 SL %	75%	80%	35%	40%	65%
3		LOB 2 SL %	50%	40%	30%	50%	80%
4		LOB 3 SL %	35%	55%	98%	74%	89%
5		LOB 1 Volume %	108%	85%	130%	150%	45%
6		LOB 2 Volume %	85%	55%	98%	42%	56%
7		LOB 3 Volume %	15%	50%	98%	74%	12%
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
Sheet1

Additional Information:

This is what I am getting whenever I do the Combo chart. I would like to have the Actual volume trend as secondary Axis per LOB plotted on top of the LOB SL

 

[Jon Peltier]

Here is what I think you want. Data in top left, your chart is my Chart1, top right.

You probably want to plot with months along the horizontal axis, so Switch Rows and Columns (Chart 2).

Now right-click on any chart series and choose Change Series Chart Type. Change each of the Volume % series to XY Scatter with Lines and Markers, and uncheck the secondary axis box that Excel so helpfully checks for you (Chart 3).

Format the lines and markers so they complement the columns (lighten the columns, darken the lines and marker outlines, Chart 4).

If you want to align the markers with the bars, you have to use different X values. These are what I computed in rows 9 to 11 in the data. For details on the calculations, see Clustered Column and Line Combination Chart and Precision Positioning of XY Data Points. In chart 5 I have used the relevant calculated rows as X values for the XY Scatter with Lines series.