J
Jill
I created a conditional chart which shows two different types of columns... one column type shows actual # days to sign a contract, and the other shows contracts that are still pending and # days it's taken so far. these are based on a fairly involved formula, with about 150 contracts
I'd like to compare the # days that's it's taken (for both types of columns) and compare them to the goal for how long they SHOULD take (2 days)
When I use a normal column chart, changing the Category (X) axis crosses at setting (i.e. 2) works as I want it to... showing contracts that were signed within 2 days below the line, and contracts that have taken longer above the line. But when I apply the same setting to the conditionally formatted chart, nothing happens
Suggestions
Thanks for your help
Jill.
I'd like to compare the # days that's it's taken (for both types of columns) and compare them to the goal for how long they SHOULD take (2 days)
When I use a normal column chart, changing the Category (X) axis crosses at setting (i.e. 2) works as I want it to... showing contracts that were signed within 2 days below the line, and contracts that have taken longer above the line. But when I apply the same setting to the conditionally formatted chart, nothing happens
Suggestions
Thanks for your help
Jill.