I have a stacked chart that needs conditional formatting dependent on YTD totals. Actuals under YTD Target are formatted Green and over YTD target are formatted Red. The Problem I'm having with the conditional formatting is when a YTD total crosses from Under to Over the Target (or Vice a Versa).
A sample of he data is below:
<tbody>
</tbody>
A stacked graph will only graph the "Above AOP" or the "Below AOP", but not the YTD total. Solution?
A sample of he data is below:
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
Target | 506 | 476 | 491 | 495 | 501 | 489 | 508 | 503 | 519 | 487 | 471 | 517 |
2018 AOP | 506 | 476 | 491 | 495 | 501 | 489 | 508 | 503 | 519 | 487 | 471 | 517 |
2018 Act | 541 | 476 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |
Above AOP | 541 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |
Below AOP | #N/A | 476 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |
<tbody>
</tbody>
A stacked graph will only graph the "Above AOP" or the "Below AOP", but not the YTD total. Solution?
Last edited by a moderator: