Forum Discussion
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
Impactful 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?
- AnonymousNot 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.
- Thejeswar
Super User
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)
- AnonymousNot applicable
Hi I want to keep the background and make the grey bar in the 100% stacked column transparent.
- Thejeswar
Super 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
Impactful 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.