Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have built a Pivot table. Its regarding various ongoing projects with phase information:
I want to color code the fields itself inside the pivot table.
1, No Issues | |
2, Some Issues | |
3, Critical Issues |
Regards,
H
Use "Background color" for the expression and implement
IF(column(1) = 'No issues',green(),
IF(column(1) = 'Some Issues',yellor(),red())
Its working but it also fills in the background color for the column name.
Please the attached file.
Regards,
H
IF(column(1) = 'No issues',green(),
IF(column(1) = 'Some Issues',yellor(),
IF(column(1) = 'Critical Issues',red(),null()))
Hi,
Write a script like
IF(column(1) = 'No issues', Green( ),
IF(column(1) = 'Some Issues', Yellow( ),
IF(column(1) = 'Critical Issues', Red( ), RGB(255,255,255,0) ) )
HTH
Regards,
Anand
Hi
write the expression for the text color then only the text color changes .
u find these options when u expand the + sign and select text folor
or else goto the properties of the chart and select custom formatiing .
then u will find the oprions of doing Bold and changing the background color.
either way it works...
Not working.
Which QV version are you using?
Please, post your qvw here, I´ll do for you
sure. I am using
Version: 11.00.11414.0 SR2
Thanks,
H
The background color bleeding to the heading is a known problem with pivot tables. Change to a sttraigt table as a workaround.
-Rob