Clustered Column Chart X Axis

Hi pxg08680,

I create an example to diescribe how the clustered column chart to disply.

my sample table
I create a clusted column chart as follows. 



At first, it will identify total distinct cagegories, in column there will be 5(a,b,c,d,e) categories shown in different colors. For each region, it will reserve 5 bar space, and the order of bar is based on the order displayed on the above(highlighted in red line circle). For the values on X-axis, it will shows all bars if there are 5 subcategories for it, otherwise there will be gap. For example, there are 4(a,b,c,d), so there will be a bar gap next to d(yellow) bar. And there is 4 bar gap before e(grey) bar for C value on axis. There is a bar gap between a(green) and c(red), a gap after d(yellow) for D value on x-axis, because there are no b and e categories for D in my table.

So for your scenario, EMEA has data from YELLOW bar to Grey bar. there is a gap becasue there are no Hong Kong Dol, Indian Rupee, Japanese Yen, Korean Won, Malaysian Ring, New Zealand D and Singepore categories for EMEA. The same way is used to NA and APAC region. We can't disable the gap until now, please review this idea and vote it.

Best Regards,
Angelia