Best visualization to show relationship between 3 variables

[Samir69]

Hi Forum

Do you know what can be the best visualization to show relationship between 3 variables (or more) ?

In my case i want to see the evolution by country of sales, opex and income.

Attached my data

Thanks in advance for your help

 

[NARAYANK991]

Hi Samir ,

You can use either a 3D graph to show the two variables ( Category viz. Sales , Opex and Opinc , Month ) for each country separately , or you can use a stacked column chart ; if you want to have only one category on the X-axis , then you need to go in for a combination clustered-stacked column chart , which is explained here :

http://peltiertech.com/WordPress/clustered-stacked-column-bar-charts/

If you want a stacked 3D column chart , go through Peltier's post in this thread :

http://www.mrexcel.com/forum/excel-...-make-3d-column-graph-using-stacked-bars.html

Narayan