I have a 100% BarChart that will have two bars, each with two peices: Bar #1: Target sales goal for the year. ........Chunk 1: Based on today's date, where SHOULD the store be for sales. ........Chunk 2: Based on today's date, how much SHOULD they have left to sell.
Bar #2: Actual sales for the year. ........Chunk 1: Sales the store has actually accumulated. ........Chunk 2: Sales remaining to meet their goal. So, let's say the following facts: 1. The store has a $100,000 sales goal for the year. 2. The fiscal year runs from Jan-Dec. 3. It is currently July (for the sake of example). 4. So far, the store has had $40,000 in sales. My bars should have the following data: Target: 1st chunk: $50,000 ($100,000/12months * 6) (bar color: blue) 2nd chunk: $50,000 ($100,000 - 1st peice) (bar color: gray) Actual: 1st chunk: $40,000 (bar color: SEE BELOW) 2nd chunk: $60,000 (bar color: always gray) Now, what I want to change dynamically on this chart is the bar color of the 1st peice from "Actual". For example, if the store is 20% below where they should be for sales, I want the bar to be red. If they are within 5%, make it yellow. Anything else and it's green. However, the kicker here is that I want to leave the Target bar colors alone. The only thing that I want to change is the Actual bar, 1st chunk. So, the question is: Within the same 100% bar chart, can you change the color of a single chunk within a bar while leaving the rest alone? Sorry for the long winded setup, but I hope that makes sense what I'm trying to accomplish. Thanks, Jake
