 Quicker Formatting Of Graphs In Excel 2007, If you can figure this out I will be SOOO greatful |
Welcome Guest ( Log In | Click here to Register a free account now! )
Register a free account to unlock additional features at BleepingComputer.com
Welcome to Bleeping Computer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.  |
 Apr 22 2008, 11:20 PM
Post
#1
|
|
|
Member  Group: Members Posts: 19 Joined: 11-June 07 Member No.: 136,041  |
 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. -------------------- here =/= hear
their =/= there =/= they're quiet =/= quite Newegg commenters can't speel! :) |
 |
 
|
|
Apr 27 2008, 10:13 AM
Post
#2
|
|
|
Member Group: Members Posts: 19 Joined: 11-June 07 Member No.: 136,041 |
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.
-------------------- here =/= hear
their =/= there =/= they're quiet =/= quite Newegg commenters can't speel! :) |
|
|
|
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 20th July 2008 - 09:01 AM |
© 2003-2008 All Rights Reserved Bleeping Computer LLC.