Hey,
I'm looking to create a sparkline that either allows me to show values above or below a constant or a win/loss where the axis is a constant that isn't zero. Specifically, I'd like to show values that are above the average for the data set and below the average for a data set.
Any ideas on how to accomplish this? I'm even willing to manually color individual markers (if I can't write a formula)
Thanks,
I'm looking to create a sparkline that either allows me to show values above or below a constant or a win/loss where the axis is a constant that isn't zero. Specifically, I'd like to show values that are above the average for the data set and below the average for a data set.
Any ideas on how to accomplish this? I'm even willing to manually color individual markers (if I can't write a formula)
Thanks,