I'm trying to create a 'stacked bar Pareto chart' - i.e. a stacked bar chart, that also shows the cumulative values for each of the two series as lines, using a secondary y-axis.Making a stacked bar chart is straightforward, as is making a Pareto cha...

I have a pivot table showing KPIs, over several months. For each KPI, there's a 'target' value, and an 'actual' value. I'm trying to set conditional formatting so that if the value for 'actual' >= value for 'target', the 'actual' cell is coloured gre...