For a complete Excel nob like me that was a very helpful article.
I may have made a mistake somewhere but I found that the negative value for Hancock in 2010 does not perform a reverse chart plot and looks a little misleading. Is this an Excel issue or me?
Nope, it isn't you. I wish I'd noticed this before -- but it's the discrepancy between the values. All the other values in in the 100k -- this one's a measly $10,000 -- try changing any of the values to $10,000 and they won't show up either -- the negative isn't the problem. It's the axis units. Sometimes you can enlarge the actual chart object, but in this case, that's not going to be of much help. I think changing the units is the only viable option to catch that. Thanks for bringing it up!
- Keyboard Shortcuts: