I'm trying to crate some charts where there are healthy zones that are dependent on age and gender - you've guessed, BMI and body fat.
As far as I can tell the colour zones can only be set as numeric values is that correct? Is it possible to amend these by getting the ranges in a custom query selected in the Update Chart Settings event?
That would be brilliant. Any ideas gratefully received.
Thanks
Alex