1 of 1 people found this helpful
Depending on the type of view you are using, you may be able to do this with a calculation and a dual axis. Another option may be to use a reference band or distribution.
If you're able to post a screen shot or packaged workbook, someone may be able to help you further.
See attached for an example (Tracey's first suggestion). I've created a calc to return 1 for when Actual > Budget and 0 if not, then I put this on the secondary axis, select bar chart and change the colour to what you want the 'background' to be. You then set the axis range explicitly to 0 to 1, and change the size of the bars so they overlap a little and you're good to go.
DynamicBackground.twbx 182.5 KB
Thank You Willem & Tracy i will try.
On Thu, Feb 27, 2014 at 2:00 PM, Willem Botha <