Help with Excel Chart

Shardey

New Member
Joined
Aug 24, 2022
Messages
33
Office Version
  1. 365
  2. 2021
  3. 2016
Platform
  1. Windows
i need to potray below table in a dynamic chart on excel.
FPS Pilot CitySanctioned
( A )
Disbursed
( B )
E_Mandate
( C )
Rejected
( D )
In Process
( E )
Total
( =A+C+D+E )
A12520115
J9230214
G12121015
H151200015
Total482071359

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
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Take the FPS Pilot City Rows as Ah, Ja, Gh, Hy
This is to avoid any confusion
 
Upvote 0
I have worked on it a bit. I now just want the 'Disbursed' column to be highligted inside the 'Sanctioned' column
 

Attachments

  • Screenshot 2024-09-22 202253.png
    Screenshot 2024-09-22 202253.png
    62 KB · Views: 3
Upvote 0
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:

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.
 
Upvote 0
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:

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.
 
Upvote 0
I haven't put the total line on but is this something like what you're looking for?

1727060408906.png
 
Upvote 0
Like this:
1727070270030.png


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
ABCDEFGHIJ
1SanctionedDisbursedE_MandateDummy_MandateRejectedDummy_RejectedIn ProcessDummy_InProcessTotal
2( A )( B )( C )( D )( E )( =A+C+D+E )
3A12520115
4J9230214
5G12121015
6H151200015
7Total482071359
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'.
1727071474281.png


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.
 
Upvote 1
Solution
Forgot to add, delete the unwanted legend entries by clicking the legend, then click the specific legend entry and press Delete.
 
Upvote 1

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top