Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a chart object formatted as table.
The table has one dimension column and four expressions.
I need to set the TITLE of the first TWO EXPRESSION columns in one color (let's say blue) and the last TWO EXPRESSION columns in a different color (let's say red).
How can I achieve that?
Thanks in advance,
Aldo.
Hello,
Try this: Goto Properties, Click on the expression then expand the + sign under that, there you see the Background Colour and text formatting...etc. So if you want to use green colour to the first 2 expressions, just type GREEN() and that is fine. same thing with other expressions, try and use Red()... Its just around this.
Hope that helps,
ANDY
I tried that, but it doesn't afect Column TITLE..
Hello,
If you are trying something in the PIVOT chart and the column title is a dimension, then thats how it works,... QV doesnt support full color formatting of column labels and sometimes the whole column itself...Maybe you can check some sample QVWs(tutorials).
Aldo,
First, turn on the design grid (View --> Design Grid). Hold down CTRT+SHIFT, right-click on your object, and select "Custom Format Cell." You can then select your title/header cell and define a custom color.
Regards,
I don't think that individual Expression labels can be formatted/colored separately. If I remember correctly, all the Headings are supposed to be the same font size, format and color. I might be wrong though, but I haven't seen how to do it yet...
With Custom Format cell, you change the color of the label of all columns. I need to set two different colors.
I tried using a calculated expression to define the background color under Custom Format Cell, but it doesn't work.
Finally, I separated my table into two different tables...
Aldo.
Did you try using rowno()=0 in the background color expression to check for the header row? I'm not sure if that will work, but it's worth a shot.
Regards,