Thanks for your deep dive into Chart formatting. It looks great. Here's a tip I picked up purely by accident. When changing data by the same amount, select the range, enter the new data in the Formula bar and press Ctrl+Enter. This fills the entire selected range without the need to copy and paste. On a whim, I went back and selected both 5% ranges and repeated what I just described. Yay! It also works on multiple ranges. It works with formulas too as long as it's the same formula.
thanks. Great explanations. How would you do something similar but with stacked data. Ex: how would you stack 5 columns of percentages (that all arrive to 100%) on that sausage bar. I'm trying to produce rounded edges on either side for each of the 5 percentages on each bar.
