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 ×îв©²ÊÍøÕ¾ 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? ×îв©²ÊÍøÕ¾ 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 and let us know your feedback comments. Know more about data visualizations.
What about conditionally formatting in ×îв©²ÊÍøÕ¾ Creator???
Bruce,You need to deplore the combo chart ASAP, without it, your software looks antiquated.Mel
Nice, but please also put it into Creator's report feature !
Bruce: Apologies for the delay. We are on it. Should be available shortly.
Nice - but not nearly as nice as combo charts. We've been waiting for combo charts (bar/line on same chart) for months... years?