Funnel Chart Font

[#1]

Hello-

Can the "Value on Data Points" font color be changed?  I can get the format of the font to change, not the color though.

[Miguel_Angel_Baeyens]

Hi,

Yes, you can do that going to the object properties, Expressions tab, and expanding the expression which value you want to change using the [+] button at the left of the expression.

There you have a "Text Color" where you can set any valid expression that returns a color code, for example, if you want the value to be red if the result of the expression is less than zero, the following will work:

If(Sum(Sales) < 0, RGB(255, 0, 0))

Hope that helps.

Miguel

[Anonymous]

miguel is rite...

n another way is jst change give the rgb color code as text color on the nided expression.

i mean is

expand the Plus sign of expression n choose text color.

[#4]

Neither of these options changed the color of the font.  Thank you for your reply though!

[Miguel_Angel_Baeyens]

Hi Tina,

I have been playing around a bit and you are right. For some reason what works in the same object if you change from funnel chart to say block chart or bar chart, where the values are correctly displayed in colors, does not work in funnels. I've opened a case in Support so they can tell us if we are doing something wrong, or this is the expected behavior, or a bug.

I'll keep you posted and thank you very much Tina for raising the question!

Miguel

[#6]

Thank you so much for opening a case in Support.  I look forward to an answer.

Have a great day!

[#7]

Hello Miguel - I too thank you for opening this case with Support.  Have they provided any updates?

Thanks very much,

Chris

[#8]

Hi,

Any luck with the font colors on Funnel charts?

Thanks,

Izabela