Chart color conditional formatting

Chart color conditional formatting

Posted by: bnguyen on 29 December 2023, 11:50 am EST

• 

  bnguyen

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 29 December 2023, 11:50 am EST - Updated 29 December 2023, 1:50 pm EST

  Hello,

  (For ActiveReports)
  
  How can we conditionally format chars (ex. Pie Chart) to have certain color based on Field Value (ex. iif (Fields!Test.Value=“input”,’ “Green”)? I tried creating iif and switch statements in the palette → custom but the field value always seems to be equal to the one same value in the Legend.

  Placing the colors without conditions in a particular order works, however, that is not what I want

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 2 January 2024, 6:20 am EST

  Hi Bryan,

  Unfortunately, there’s no way to specify custom colors based on a specific field’s value in a PageReport.
  
  However, you can change the chart’s palette to ‘Custom’ and in the ‘CustomPallete’ property add the list of color items that you want your chart to use. However, the first data in your dataset will pick the first color from the palette irrespective of the data value.

  Please find attached a sample implementing the same for your reference.

  You can learn more about using a custom palette here: Chart Palette.

  Regards,
  
  Anand

  CustomPalette.zip