A chart makes it easy to see a trend over time or to compare how different figures stack up. To achieve a similar effect with plain tabular data is difficult, but not impossible! That’s what conditional formatting in Zoho Analytics achieves.
Conditional Formatting of Tabular Data
You often see conditional formatting applied to financial data, where positive values are typically in green and negative values in red. A similar example below, where we show the best ‘CTR’s in green, the bad ones in red and the intermediate ones in yellow. You can apply color to the cell background and to the font (‘Clicks’ column in the below example).
Definitely easy to identify outliers and easy to comprehend, right? Zoho Analytics now supports conditional formatting in base tables and query tables. We will be extending it to pivot and summary tables soon. You can access conditional formatting by right-clicking on a column.
Area and Stacked Area Charts
We have been continuously adding new chart types. The latest ones to come in are area and stacked area charts.
Try conditional formatting and area charts in Zoho Analytics and let us know your feedback comments.