It came as a great surprize to hear that there was a "modeless Format dialog
box" with which multiple changes could be made to Excel 2007 charts. I was
so encouraged by your comment that I immediately opened up an Excel 2007
spreadsheet & chart to explore the possibilities. Unfortunately, the new
ribbon commands didn't include any obvious reference to said functionality,
nor did the "help" function perform its duty in any combination or subset of
"modeless Format dialog box". I can only assume that this function remains
"a riddle, wrapped in a mystery, inside an enigma"; much like the rationale
for the new ribbons, despite what is stated on
http://pschmid.net/blog/2006/10/09/58 . Obviously, if an experienced user
can't find a function, there is a problem, and it doesn't lie with the user.
I had later purchased the third-party "classic" menus provided by
http://www.addintools.com/english/menuoffice after a few weeks of floudering
with Excel 2007, and while their menus are a welcome respite to the new
ribbons, they seem to provide about 90% of the previous functionality of
Excel. Reverting to an earlier version of Excel was more expedient than
continuing to deal with Excel 2007.
"Every good idea deserves a decent burial", and while I don't expect those
committed to the ribbons to kill off their invention, I'd truly appreciate
the reinstatement of the efficient functionality of the menus. If the user
has to hunt for the occassional odd menu command, that's a small price to pay
for overall effectiveness and efficiency.
"Beth Melton" wrote:
Did you find the modeless Format dialog box? It's the one you can use to
change multiple options, each change you make can be viewed immediately
(which is great when you're not sure about the specific look you're after)
and since it's modeless you can leave it open, select another element and
modify it as well - no need to open and close dialog boxes.
I've found this method to be far more efficient than double-clicking an
element, make my changes, click OK, find out I didn't like something,
double-click the element again, make more changes, click OK and repeat the
process for each chart element I want to modify.
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
Co-author of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/boo...x#AboutTheBook
Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
"joe_btfsplk" wrote in message
...
As an example, in Excel the simple reformatting of a line on a graph used
to
be accomplished by double-clicking on the line, and adjusting all line
characteristics at once. Now, the double-clicking doesn't work, and each
individual line characteristic must be changed individually, in a number
of
different windows.