Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

stacked column chart

Hi,

I am using the stacked column chart as follow

I placed two fields (Field1, Field2) in value and Field3 into Axis

Field1 value is 3Millions and Field2 is 5Million

At present as standard, Field2 sits over the top of Field1 as a column

For example, Field1 starts from 0M and goes up to 3M in chart, then on top of Field1 value, Field2 starts and goes up a further 5M, i.e. it goes to the 8M y axis. Which is the standard look of stacked column chart.

Question:

I would like Field1 and Field2 to overlap each-other instead of Field2 starting from the tip of Field1

so that both start from 0M. Field1 goes up to 3M as it is now but Field2 value to start from 0M and go up to 5M

I guess what I am after is clustered column chart bu overlapping not next to each other bars for every occurance of teh value in X axis

Hoe you know what i mean.

 

Thank you

3 Replies

  • Hey Anonymous ,

     

    maybe you want to use the custom visual "Bullet Chart by OKViz" from the marketplace, that's available free of charge.

     

    I created this

     

    From the formatting options of the visul I

    • switched orientation to vertical, available in the General band
    • switched the states to off

    Hopefully this is what you are looking for.

     

    Regards,

    Tom

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello,

      This looks better, however, I would like to have the width of the vertical bars to be the same

      thank you

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    Hi Anonymous 

    This is standard look of stacked column chart.

    The clustered column chart is possible.

     

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.