Thread: Excel 2007 Charts Complexity

In Excel 2007 I find the number of charts that can be used overwhelming.
Especially when you click on the drop down menu of which chart to use.
Personally, I would think it to be more helpful if you could quickly go
through what you want to do step by step.
For example if I wanted to do a graph: 2D or 3D, then pie , line, other,
then colours.

I find especially the part when you actually want to change your colours and
setup of a chart confusing. I do admit that the new look is appealing -some
might like it some won't but at least you have a choice what look you want.

But when I tried to get my percentage values into the diagram I had real
trouble doing so. When I specified a certain graph with percentages, some
percentages were too small and overlapped. When I dragged them away, the line
which pointed to the section of the graph disappeared. When I tried to
manually enter some new writing into a specific textbox, excel would not let
me do it.

Maybe I just have to get used to it and find my way around, but on older
versions it was more intuitive and I could quickly change what I wanted (for
example click into a textbox and just add for example numbers). That is to
say I am not a complete expert on excel but probably better than average and
excel did not support the way I wanted to work away - it took me very long to
get what I wanted and that surely is not the idea.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

The whole thing seems to be geared to the inexperienced and really just
seems to make it harder to find all the things you already know you
want to use. I understand that they want more people to use more
features but they're effectively burying the stuff regular users access
all the time. They should come up with an option to use an
"experienced" level interface. What I miss most is the hotkey
indicators on the menu bar - because there is no menu bar. The
shortcuts are still there, so the ones I have completely memorized
still work, but I don't have the bootstrap of glancing at the
menu/dropdown to make a one-off choice.

I guess we'll all learn how to dig out the stuff we need.

We'll either just have to get used to it, or stick to Excel 2003. (I still
have clients on Excel 2000.)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"ward376" <cledwards1376@gmail.com> wrote in message
news:1149489705.718030.160230@g10g2000cwb.googlegroups.com...
> The whole thing seems to be geared to the inexperienced and really just
> seems to make it harder to find all the things you already know you
> want to use. I understand that they want more people to use more
> features but they're effectively burying the stuff regular users access
> all the time. They should come up with an option to use an
> "experienced" level interface. What I miss most is the hotkey
> indicators on the menu bar - because there is no menu bar. The
> shortcuts are still there, so the ones I have completely memorized
> still work, but I don't have the bootstrap of glancing at the
> menu/dropdown to make a one-off choice.
>
> I guess we'll all learn how to dig out the stuff we need.
>