However, part of requirement is to use different colors on the actuals column depending on if the amount is less than or greater than the plan amount. For example, if the actual sales amount is greater, the column would be green but if it's less then it would be red.
I wasn't able to discover a way to set the interior color of individual points in the chart. Is there a way to do this?
I've attached a quick mock-up that shows what I'm looking for based on the demo chart I mentioned above. In the mock-up, you can see that the color changes when the values of certain columns exceed a target value.