Hi,

I'm creating a bar chart that shows actual revenue compared to budget for 5 departments. I am using on change of department show budget and revenue. My problem is that the bars for budget and revenue are the same color so you don't know which is revenue and which is budget. I did use the highlight tab to change color of the budgeted amount to a lighter shade. But this tab uses the value of the budget which changes monthly. Is there a better way to show budget vs actual in a report or a way to change one of the values (budget or revenue) color permanently?

Thanks for your help.