Some of you might have seen my previous blog posts sharing the steps on how you could use a Google Sheets in combination with Cloud for Analytics (C4A) and how you could use the data in combination with maps.


This time I wanted to setup some conditional formatting as part of my charts.


I did start with a simple chart displaying the Revenue across twelve month.



As next step I wanted to setup some rules – for example comparing the actual revenue with the forecast and based on the target achievement I was going to color code the column in the chart – but then I noticed that there is no conditional formatting for charts at this point in C4A.


The I did find the option to add a reference line, which was the closest option to what I was looking for.





Using the Reference Line option, you can choose between a Fixed or a Dynamic Reference Line. In my example I selected the dynamic reference line and I selected the Revenue as base for the reference line. You can then choose the aggregation – Max, Min, Average – and you can then configure the color for the area above and below the reference line (shown above).


Even though the reference line wasn’t 100% of what I was looking for, I am sure that it will be helpful in other scenarios.


Additions to my wishlist for C4A:


  • Ability to define conditional formatting for charts
  • Ability to define conditional formatting based on measure comparisons (Actual Revenue vs Forecast)
To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply