Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Transparency Colour for one value in a stacked column chart

Hello, I've been searching for a solution for this and have not found anything online.

 

I'm trying to change the colour of one value in a 100% Stacked Column chart. I want to do this so the background colour can be seen and also this last value (grey column) in the stack is not essential. This is what I currently have and the second image is what I would like to be able to do.

 

Any help would be appreciated.

 

 

 

12 Replies

  • PVO3's avatar
    PVO3
    Icon for Impactful Individual rankImpactful Individual

    The conditional formatting of backgrounds for some visuals do not work. Isn't this just simply fixed by removing background of the chart and use a shape or an image in the background? Or you want this to be dynamic?

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi, sorry if it isn't clear. I want to keep the background and make the grey bar in the 100% stacked column transparent. As the second image shows.

  • Hi Anonymous ,

    In the visual properties, you will have a background section where you can set the transparency property.

    In the below ss, although I have a grey background, since my transparency is 100%, my visual looks white (fully transparent)

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi I want to keep the background and make the grey bar in the 100% stacked column transparent.

      • Thejeswar's avatar
        Thejeswar
        Icon for Super User rankSuper User

        Hi Anonymous ,

        If this is an image that you are using for background, you might have to remove the image.

         

        The Earlier suggestion I gave was for if you are using a colour fill as your background. In case you are using both background image and color, making this background color transparent is not going to have any impact on your background image

         

        By the way, is the grey bar the value that you have made up just to fill the visual with an idea of hiding it later?

  • PVO3's avatar
    PVO3
    Icon for Impactful Individual rankImpactful Individual

    Ahh the grey is just a category you visualy would like to hide. So basicly you want to use a 100% stacked column, just because it gives a 100% axis. I would say, use a stacked column chart and create a 100% axis.