Once you fill in your new colour Excel picks thats up for when you select the next cell above / below. No need to hold anything down - just literally follow the video step by step
I really want to know how to create these diagrams properly but this vid is not clear to me at all, esp since there's no audio. the part that confuses me the most is when you unfill and re-colour segments in some automatic mode. Is there a key you hold down or something? Please elaborate..... thanks so much.
Can you do this where each segment is graduated at a different rate? e.g. All segments have a max of 50. Segment 1 graduates at 5, 15, 35, 50. Segment 2 has 1, 17, 38, 50. Both segments need to align, so Segment 1 - 15 needs to line up with Segment 2 - 17. Possible? If so can you give some pointers?
the coding you typed in to the box for the scale of 1-10 in columns f and g, it doesn't work. I get a N/A response. I Really need help fixing this so it can work.