I made this fun little game where you have to hit a certain target each quarter. Or you'll get fired. It's a strategy/RNG game where you try to figure out different synergies to be able to hit the target. Don't play if you have anything productive to do!
I recently bought an Excel course, but the instructors said we'll be doing all the lessons and exercises in Google Sheets because the two programs are supposedly 95% identical.
I'm curious if that's really the case. What do you guys think?
I have a set of graphs that automatically update to reflect the last 6 weeks of data. These measure performance in terms of success rate, and all have a set target percentage that we want to hit/exceed. Currently the lines are all constant colors, but I would like to have the lines of each graph change color to show if they are meeting target or not for that week of data.
I could see this being presented 2 ways:
- If the value is below target, that entire line segment (last value to current value) turns red. If above, the entire line segment is green.
- Any part of the line that is below the target line turns red.
What is the best way to automate this in Excel 365? Obviously I could just manually change the color of the line segment, but I feel like there has to be a better way. I briefly messed around with gradient lines, but could not find a way to make the cutoffs automatically update as data changed. I also considered creating dummy columns to split the data into 2 series, 1 red and 1 green, but that was not displaying how I wanted, and the lines were not connecting.