calvin peters 6/7/2024 8:55:50 AM At a guess I would think the problem you're encountering is with the limits to colorization based on grouping and chart type. Bar charts , for whatever reason , don't support colorization using reference to columns: The error is: Row colorization formula for this chart type can not use columns
I don't really understand it either but if you switch to a pie chart and use some formula like ToDays(Today()-[your date column] <10, "fav color here", ToDays(Today()-[your date column] <20, "next fav color here", etc
I think you'll get what yo're after...
place your formula in the ADVANCED OPTIONS section of your view setup form...but you likely already got that far to get to this question I imagine...
|