Column Chart - Change axis to quarter but keep monthly colums

[JotaL]

I wanted to simulate in a column stacked chart a target vs realized quarterly evolution of Gross Margin as shown below. 

To do this, I had to create 3 calculated columns:

Target - populates only months 1, 4, 7 and 10

Gross Margin Red - takes realized gross margin only when it is below target, if not zero, and populates only months 2, 5, 8 and 11

Gross Margin Green - takes realized gross margin when it is above target, zero otherwise, populating also months 2, 5, 8 and 11

For Months 3, 6, 9 and 12, all calculated columns will return zero.

These columns were used then in a stacked column chart, as referred, with monthly values, but the idea is to look in fact a clustered columns chart representing the quarters, with a space between the cluster (achieved by having just zeros in months 3, 6, 9 and 12). It works quite fine, I can even emulate conditional formating for realized gross margin. The only downside is the fact I see the axis in months. I would like to see quarters, and only once per quarter.

Any ideas on how to do it?

[v-xiaotang · Accepted solution]

Hi @JotaL 

Sorry for not very clear about result you want, do you mean you want the Stacked column chart to show like this?

if so, i'm afraid this is impossible.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[JotaL]

Thank you. It is exactly what i was looking for. I guess I will have to some manual tweaking.