Best way of representation guide please

[#1]

I have Region and Country as below.

Region    Country

NOAM    USA

APAC     China

APAC     India

APAC     JAPAN

LATAM    Argentina

LATAM    BRAZIL

What is the best way of graphical representation of Country by Region.I did use the pivot table but the customer wants some kind of graphs in it...How can I show them the data in graph ? Which chart can I use ?

Thanks much.

[Mark_Little]

HI,

We the is a few different options.

You could just have a bar Chart then has two as dimension, then show them grouped. Or you can set up a drill down and show on most charts.

Mark

[#3]

Thank you Mark.Can you post a sample with 2 dimensions ? I tried and doenst look good.

[Mark_Little · Accepted solution]

Take a look

Mark