trying to separate columns while using clustered column chart

[Anonymous]

Hi,

I'm still very new at this but understand a few basics. I'm trying to produce a report (see image below) that displays data from two different locations but the same measurement type. Everything is working except that  I want to create some space between the columns that identify the location. For example, I'm trying to make some space between the dark and light blue columns and the orange and purple columns. 

[parry2k]

@Anonymous check these settings on format pane

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[Anonymous]

 Hi @parry2k . I gave that a shot and it gave more distance between the sets. I'm trying to separate the sets like this.

[mihart · Accepted solution]

Hi @Anonymous 

If you area trying to break up the clusters, it is not possible.  For example, if you're looking for the 2 blue columns to be together and the two red-ish columns to be together -- can't do it.  But if you're looking for more space between clsuters, that is doable see below.

HTH

Michele 

[Anonymous]

 I was afraid of that. Thanks for the answer though.

[V-pazhen-msft]

@Anonymous 

I try test with a random data table, but I can't make it look like your chart. Can you share a sample table.

Regards
Paul