Hi Phil,

A number of people have written workarounds for your issues. See below.

Excel seems to have been primarily designed for accountants but it is also
useful for handling scientific results. Unfortunately the graphing side is
missing a number of important features. It would be useful to know,
whether
any of these features are going to be included in the next release of
Office.
Is there a feature list available yet?

1) Point and Click Scaling
It is a real pain having to go and type numbers in to change the scale
limits. Often you just want to zoom in on an area. There are several ways
this could be done, either a simple point and click to zoom in; or allow
user
to define a rectangular area by dragging out a rectangle with the mouse;
or
by placing two cursors on an axis to redefine the end points.
Also when you change the scale on the x-axis, it would be extremely useful
to have an option to autoscale the y-axes, ignoring the data where the x
value is outside the new limits.

Check out Zoom Charts at http://edferrero.m6.net/charting.aspx

2) 3rd and 4th axes
Often you have more than two quantities that you want to display on one XY
chart against the same x-axis. Why does Excel limit the number of y axes
to
2? There is enough room for 4 axes by using both sides of each axis line
for
the axes labels. Alternatively there is no reason why further y axes
couldn't
be added at any arbitrary point on the x-axis, they don't have to be at
the
ends.
It would also be nice if the axis colour could optionally be linked to the
series colour (obviously this would only work if the colour for every
series
on the axis was the same).

See Jon Peltier's Tertiary Y-Axis at
http://peltiertech.com/Excel/Charts/TertiaryAxis.html


Ed Ferrero
http://edferrero.m6.net/