Alright, I made the transition to Office 2007 at the beginning of this semester, and for the most part I've gotten my game back. I was really efficient and skilled in 2003 and, well, any high-skilled users know what happens when you initially switch

Anyways, I've figured everything out but graphs. Say I make a graph, and the y-axis data ranges from 50-200. By default Excel will scale the y-axis to zero. In 2003 if I wanted to change axis properties I could double click, then the properties would be right there. Now in 2007 I seem to have two options: right click > (all the way at bottom) axis properties, or Format > little arrow thingy > Vertical axis (oh my the laymen-ness of that one made me cry a little the first time I saw it) > Format selection. Oh and if I go this second way, every time I click away from the graph and click back I have to click on "format" again, despite all of Excel's smartness.

Is there a faster way to do this? I know it sounds silly, but right click > format axis is seriously slowing down my productivity. Add to that that once I finally get to the freaking dialogue box I can't just type in a new minimum value, I have to check the box THEN I'm allowed to change my axis.

I'm guessing nobody knows how to do this, and based on my findings in the other Excel 2007 thread, MS probably removed this feature for no apparent reason. Why they would go to the trouble of *removing* a useful feature I'll never understand, especially when they didn't replace it with anything you couldn't already do.