Best visual to compare multiple values across 2 Groups/categories

[Husain]

Hi guys,

What do you think is the best visual to compare multiple values across 2 Groups/categories.

I tried with Column chart and Tornado but they look horrible becasue the 2 bars/columns to be compared are not sized according to each group of 2 values separately.

Here is the sample data. Comparing Military power of US and Russia(RU)

Main Category	Sub Category	US	RU
Air Forces	Fighter aircraft:	457.0	751.0
Air Forces	Helicopters:	4,889.0	1,505.0
Air Forces	Multirole aircraf:	2,192.0	526.0
Air Forces	Total aircraft:	12,304.0	4,441.0
Air Forces	Attack aircraft:	587.0	783.0
General	Area:	9,857,306.0	17,098,242.0
General	Population:	324,527,000.0	144,554,993.0
Land Forces	Total artillery:	3,269.0	14,557.0
Land Forces	Armoured fighting vehicles:	41,760.0	27,335.0
Land Forces	Rocket artillery:	1,197.0	4,032.0
Land Forces	Self-propelled artillery:	950.0	5,955.0
Land Forces	Tanks:	6,393.0	20,050.0
Manpower	Available for military:	73,270,043.0	34,765,736.0
Manpower	Reserve personnel:	811,000.0	2,000,000.0
Manpower	Active personnel:	1,281,900.0	771,000.0
Military expenditures	Military budget:	610.0	66.3
Military expenditures	Percent of GDP:	3.1	4.3
Navy	Total naval:	437.0	314.0
Navy	Aircraftcarriers:	20.0	1.0
Navy	Corvettes:	0.0	83.0
Navy	Destroyers:	85.0	18.0
Navy	Frigates:	0.0	10.0
Navy	Submarines:	71.0	59.0

[Greg_Deckler]

It occurs to me that the problem is not the visual but that you need to normalize those numbers. Like:

Normalized = [US] / [RU]

Then put that in a graph. Note, in this circumstance you would not unpivot the last two columns.

[Husain]

Hi @Greg

Thanks for your help.

Could you illustrate this in the form of a chart with the help of sample data I provided above

Many thanks in advance