3 variable histogram

DTRoen

New Member
Joined
Sep 26, 2014
Messages
1
Hello,
I am trying to use Excel to produce a 3 variable histogram comparing both the number of employees and their pay scales across three different divisions. The intent is to show both size differences between divisions, as well as how much more "top heavy" a division may be.

The x-axis would be bins for the three divisions, the y-axis would be the count of employees, and I would like to display pay scale using column width. Imagine stacking legos, with small legos at the bottom corresponding to lower pay scales, and wider legos at the top corresponding to higher pay scales. Any advice?

Note: I am a government employee, so I will not be able to download any add-ins.

Thanks in advance.
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

NeonRedSharpie

Well-known Member
Joined
Jul 14, 2014
Messages
1,678
Create a stacked bar graph, and then manually adjust the width of the individual sections.
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,779
Office Version
  1. 2010
Platform
  1. Windows
There's gotta be a better way than manually adjusting columns widths, and there are certainly more common ways. You might Google income distribution curves and lorenz curve
 

Watch MrExcel Video

Forum statistics

Threads
1,122,207
Messages
5,594,840
Members
413,944
Latest member
3xc3ln00b

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
Top