Hello all,
I have a table with two types of percentages based on a time period:
Predicted
Achieved
I plotted the graph, but I wondered if it is possible to conditionally format the markers of the Predicted series.
Eg:
At week 41 I predicted 2.5% and achieved 2.5%. Green marker.
In week 43 I predicted 2.5% and achieved 7.5%. Green marker.
In week 46 I predicted 17.2% and achieved 15%. Red marker.
https://drive.google.com/open?id=15UHrRHGVhDLmKlRF9t-PmCzkaCMfN5Af
Best Regards
I have a table with two types of percentages based on a time period:
Predicted
Achieved
I plotted the graph, but I wondered if it is possible to conditionally format the markers of the Predicted series.
Eg:
At week 41 I predicted 2.5% and achieved 2.5%. Green marker.
In week 43 I predicted 2.5% and achieved 7.5%. Green marker.
In week 46 I predicted 17.2% and achieved 15%. Red marker.
https://drive.google.com/open?id=15UHrRHGVhDLmKlRF9t-PmCzkaCMfN5Af
Best Regards