Although it's a stunted little graphing facility, it has great flexibility,
both in terms of combination charts which use additional series to achieve
certain functionality as well as programmability to do it repeatedly and
effortlessly. Excel allows you to hack together features that you would
otherwise need to purchase an expensive specialized software package for,
and that package wouldn't do all the other things that a spreadsheet can do.

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


"Del Cotter" wrote in message
...
On Thu, 10 May 2007, in microsoft.public.excel.charting,
Rab said:
But...after however many versions of excel, why does it still fail to be
able to perform so many desirable functions in a simple way via the chart
wizzard? If I want to generate charts with different chart types for
different series, multiple y-axes etc it seems that there are a lot of
counter-intuitive things going on. Please sort it out microsoft!

I sympathise, but remember that Excel is not a graphing program, it's a
spreadsheet. Once upon a time, there were graphing programs that were sold
separately, with names like Harvard Graph and Lotus Freelance, but the
demand doesn't seem to have been there for these programs to be developed.
The business market seems to be satisfied with a stunted little graphing
facility embedded in a spreadsheet.

(and yet the same big business customers demand that that little graphing
facility must have fancy metallic-look visual effects. go figure.)

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.