Hello,
Excel noob here. I have a formula SUM(SUMIFS('Sheet1'!E:E,'Sheet1'!F:F,"Cond1",'Sheet1'!D:D,{"Cond2_1","Cond2_2","Cond2_3","Cond2_4","Cond2_5"})), which logically ANDs condition "COND1" on a column with ORed 5 possible values of interest for a different column to sum appropriate rows from a 3rd column. Works great!
This sum is displayed in a bar chart. What I would like to do is color code sub-sums from the ORed check differently so the bar shows as a composite of 5 different possible colors; one for Cond2_1, one for Cond2_2......one for Cond2_5. Can this be done?
Thanks!
Bookmarks