Help with Excel Chart

[Shardey]

i need to potray below table in a dynamic chart on excel.

FPS Pilot City	Sanctioned ( A )	Disbursed ( B )	E_Mandate ( C )	Rejected ( D )	In Process ( E )	Total ( =A+C+D+E )
A	12	5	2	0	1	15
J	9	2	3	0	2	14
G	12	1	2	1	0	15
H	15	12	0	0	0	15
Total	48	20	7	1	3	59

Challenges - Disbursed column is to stacked inside sanctioned column
&
both totals - across rows and columns are to be shown somehow

One single chart is preferred but if not possible, then two charts can be made out of this

 

[Shardey]

Take the FPS Pilot City Rows as Ah, Ja, Gh, Hy
This is to avoid any confusion

 

[Shardey]

I have worked on it a bit. I now just want the 'Disbursed' column to be highligted inside the 'Sanctioned' column

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Help with Excel Chart

i need to potray below table in a dynamic chart on excel. 879466 Challenges - Disbursed column is to stacked inside sanctioned column & both totals - across rows and columns are to be shown somehow One single chart is preferred but if not possible, then two charts can be made out of this

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Shardey]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Help with Excel Chart

i need to potray below table in a dynamic chart on excel. 879466 Challenges - Disbursed column is to stacked inside sanctioned column & both totals - across rows and columns are to be shown somehow One single chart is preferred but if not possible, then two charts can be made out of this

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Sure. Just needed help urgently. Got your point as well.

 

[myall_blues]

I haven't put the total line on but is this something like what you're looking for?

 

[Shardey]

I haven't put the total line on but is this something like what you're looking for?

View attachment 117175

Yes. Can you please add the line part as well? And check.
If all is well, please share the whole solution

 

[myall_blues]

Like this:

To make this graph you need to insert some dummy columns - sanctioned and disbursed make a "pair", and you need to insert additional columns to make a pair with each of the others as shown in highlight below.

Book1
	A	B	C	D	E	F	G	H	I	J
1		Sanctioned	Disbursed	E_Mandate	Dummy_Mandate	Rejected	Dummy_Rejected	In Process	Dummy_InProcess	Total
2		( A )	( B )	( C )		( D )		( E )		( =A+C+D+E )
3	A	12	5	2		0		1		15
4	J	9	2	3		0		2		14
5	G	12	1	2		1		0		15
6	H	15	12	0		0		0		15
7	Total	48	20	7		1		3		59
Sheet4

Now select the range A1:J7 and insert a 2D clustered column chart. Click on the chart and under Chart Design->Data Group you will probably need to click Switch Row/Column. Now select any series, right-click and select Change series chart type, and for the disbursed series and all the 'dummy' series check the box to put them on the secondary axis. For the 'total' series, change the type to 'Line with markers'.

Finally, change the secondary axis bounds to match those of the primary axis (i.e. 0 to 60) and format the various series how you want them to appear.

 

[myall_blues]

Forgot to add, delete the unwanted legend entries by clicking the legend, then click the specific legend entry and press Delete.