Hi I have the attached bar chart.
For some reason I cannot get the colour to change, it seems as though its spliting the colour by year but i need it to weighted average and the avg days incoice to last payment to be a different colour.
How do I do this?
You need some workaround using Dual axis chart to achieve your requirement. Please see to the attached workbook and below screenshot.
Please let us know if you are facing any issues. Hope this helps.