I have a trellis chart which works ok, but we want to have each chart in a different colour specific to the dimension so that it coordinates with a different overview chart.
So, I merrily went in a put in a formula in the background colour in the expression page and suddenly, the charts in each segment squashed up fo no reason. The colours worked fine, but I don't understand why that would affect the chart layout.
Can anyone help? I've attached a picture to try and illustrate.